About EricL

EricL · ‎09-17-2017

Impala does not support DATE data type, please refer to Cloudera doc: https://www.cloudera.com/documentation/enterprise/latest/topics/impala_langref_unsupported.html You mentioned you changed to timestamp, it also failed, can you please let me know how you made the change?

EricL · ‎09-17-2017

Please enable trace logging on ODBC and examine the log for hints. See user manual: http://www.cloudera.com/documentation/other/connectors/hive-odbc/latest/Cloudera-ODBC-Driver-for-Apache-Hive-Install-Guide.pdf on how to enable trace logging for ODBC driver.

UjjwalRana · ‎09-09-2017

I am able to solve the issue. I simply uninstall and re-install hive and with that it works. Select query is now able to show an output without any issue.

EricL · ‎08-20-2017

Hi Francesco, Why do you need to read from an empty parquet file? Can you simply remove them? Have you also tried to use parquet-tools command line utility to confirm if the parquet file is valid?

EricL · ‎08-20-2017

Hi, I believe that you are hitting https://issues.apache.org/jira/browse/HIVE-14037. HIVE-14037 has been fixed from CDH5.9.0 onwards. Did you create function with "USING JAR" keywords? If not, please give it a try to see if it will help. Otherwise, upgrade to latest CDH should help.

Classified123 · ‎08-16-2017

Excellent, I think this is it. I'm testing it out right now so I might be a little premature in celebrating but it seems to be working out right now. Thanks again for the tip!

EricL · ‎08-02-2017

Hi, As the error message indicated, UNION ALL is not supported at top level, you need to put it in a sub query, similar to below: SELECT loc, cnt FROM ( select a.loc as loc, a.cnt13 cnt from crimeloc13 a UNION ALL select b.loc as loc, b.cnt14 as cnt from crimeloc14 b ) a;

Venkatk99 · ‎07-12-2017

The query executes with map reduce engine and I get the desired result. The error happens when I switch to spark engine.

Garren · ‎07-12-2017

My issue here ended up being brought by Amazon elastic load balancer timing out after 60 seconds.

EricL · ‎07-11-2017

Hi yueyang, Can you please share your impyla source code and the error you are getting? That will help me understand why it failed. Thanks

Online	Offline
Last Visited	‎08-12-2020 03:17 AM

Member Since	‎03-23-2015 01:24 PM
Last Visited	‎08-12-2020 03:17 AM
Posts	1,288
Kudos received	113

Cloudera Community

Re: max() function generating an error in sqoop

Re: Add a dynamic variable to a Hive view

Re: Hive Server 2 failing to start CDP ,Cloudera M...

Re: Sqoop export from hive to teradata - > issue ...

Re: Cloudera Hadoop internal workings

Re: Unsupported Datatype

Re: ODBC Hive [Cloudera][ThriftExtension] (6)

Re: select query inside hive not working

Re: Hive Error when reading empty parquet files

Re: hive.reloadable.aux.jars.path not working prop...

Re: Is there a REST health check for the impala da...

Re: ADD TWO TABLES IN HIVE

Re: Hive on Spark Exception

Re: Hive session times out after 60 seconds

Re: How to use python connect impala with kerberos...