No longer get the result from my query

bagdwan1 — Wed, 02 Mar 2016 14:13:57 GMT

Hello,

I have an extract application that extracts data from Hive/Hadoop. For the last 4 months this has been working but 2 days ago it stopped working.

What happens is that the query is run and it is completed as well when we look at the logs in Hive but QV never gets the result.

The log looks like this:

2016-03-02 14:35:38: 0323 SQL SELECT

2016-03-02 14:35:38: 0324 *

2016-03-02 14:35:38: 0325 FROM networksm

2016-03-02 14:35:38: 0326 Where

2016-03-02 14:35:38: 0327 from_unixtime(cast(rounded_timestamp/1000 as bigint)) > '2015-12-02'

2016-03-02 14:35:38: 0328 and from_unixtime(cast(rounded_timestamp/1000 as bigint)) < '2016-03-02 14:34:57'

2016-03-02 14:36:39: 10 fields found: product_id, software_version, software_variant, build_type, cdf_id, imei, state_machine_name, state_name, time_in_state,

As you can see QV gets a response 1 minute after the query is started but it never gets the rows.

It also seems that it works when I run the application on my own computer (both with my user account and the service account) but it doesn't works when it is reloaded via the publisher using the service account.

We tried upgrading the odbc driver to the latest version (Clouderas) but this did not solve the problem.

We have other extract application that are still working. The only difference is that this application uses a different database.

Has anyone seen the same problem or has any idea how to solve this problem?

Martin

topic No longer get the result from my query in QlikView

No longer get the result from my query