we're using Cloudera 4.3 with Hive 0.11 on a six node Hadoop Cluster.
PowerPivot 64bit and ODBC Connector for Hive is installed.
When trying to apply a filter on a string column (like a date field) in a table in database "myschema", error message
ERROR [HY000] [Cloudera][Hardy] (22) Error from ThriftHiveClient: Query returned non-zero code: 40000, cause: FAILED: ParseException line 1:9 cannot recognize input near '[' 'myschema' ']' in select clause
So the statement looks like this:
SELECT [myschema].mycolumn1, ... from [myschema].mytable
Using other ODBC Connectors (MapR, Hortonworks, ...) had no positive effect.
Switching to Native Query in ODBC Connector shows no improvement.
Other tools like Tableau, Qlikview worked properly.
So the problem is the query creation in PowerPivot. The square brackets seem to be at least part of the issue.
Without the capability to apply filters on any not-integer column usability of PowerPivot with Hive is drastically reduced.
A fix of this issue is highly appreciated.
Any ideas for Zap?
Ed Price, SQL Server Customer Program Manager (Blog,
Answer an interesting question?
Create a wiki article about it!
Is this still an issue?
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?