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?
br
Martin