I know it's a Saturday, but I'm really hoping there are some losers like me out there doing some work/monitoring the Community posts - ha. I'm working on an on-demand app and got the Selection app template built and working. I'm now trying to get the Details app template working but running into a hiccup.
I'm connecting to a Hortonworks Hive table.
Basically, I'm trying to execute the SQL command below and I’m getting the following error:
Initially, while debugging I kept parsing down the dynamically created WHERE clause [$(WHERE_PART)] until it was an extremely basic where clause (e.g., WHERE facility = "NEW YORK") and that was still producing the error. Then I even hard coded ‘WHERE facility = “New York”’ and received the same error. If I remove the where clause, the sql executes fine, so the problem seems to be within the Where clause.
I’m a little worried because I did some research and found the following Community post:
I am facing the same issue. I cannot use a WHERE clause or GROUP BY or even a simple function on the query. I can only read the table with no modifications. Did you find any answer about this? I don't know if the problem is with the ODBC connector or it is a bug from some Qlikview version or what else...
So it turned out the Hive data source itself was not optimized at all. Based on the way it was structured, when you tried to run the same query directly on the data source (outside of Qlik) it hung as well. The error I received within Qlik was just due to a query timeout. If you can, I would try to run the same query on the data set outside of Qlik. It took me a while to determine this because I didn't have access to the data source and was relying on someone else to run the query for me.