Re: Invalid Exchange Node Non-Child Time

jbapple · ‎06-11-2018

Have you tried hadoop distcp?

jbapple · ‎02-09-2017

You forgot the echo.

jbapple · ‎11-02-2016

In what way did it make things worse? When you tried -q, did you drop the "-f user.sql" part off of your command line? Did you add "show databases" right after -q?

jbapple · ‎10-25-2016

What version of Impala? Does this happen with -q "show databases" instead of -f user.sql?

jbapple · ‎10-24-2016

What do you see if you type "use new_db_from_hive;" into your Impala shell?

jbapple · ‎07-26-2016

Can you attach a full profile?

jbapple · ‎07-24-2016

One way is the REQUEST_POOL option. Other ways are listed in these locations: http://www.cloudera.com/documentation/enterprise/latest/topics/cm_mc_resource_pools.html#concept_rmc_2pf_jn http://www.cloudera.com/documentation/enterprise/latest/topics/impala_admission.html#admission_guidelines

jbapple · ‎06-20-2016

You can follow the bug I linked to above for any future updates. Right nowI have no news for you.

jbapple · ‎02-05-2016

http://www.cloudera.com/documentation/enterprise/latest/topics/impala_udf.html#udf_tutorial_unique_1 describes the mechanism for using UDFs with Impala. It does not describe an Impala restart.

jbapple · ‎02-04-2016

No, it does not affect the timeline.

jbapple · ‎02-04-2016

This is apperently a bug that has been fixed in more recent versions: https://issues.cloudera.org/browse/IMPALA-2075

jbapple · ‎02-03-2016

I do not know, but I have sent the person who will a link to this forum question and asked her to tell you if she knows.

jbapple · ‎02-03-2016

The client itself should tell you, ("Fetched 1 row(s) in 0.31s") or your can run "profile".

jbapple · ‎02-03-2016

See https://issues.cloudera.org/browse/IMPALA-2732. In a recent build: > select unix_timestamp('10/20/2007', 'M/d/yyyy'); Query: select unix_timestamp('10/20/2007', 'M/d/yyyy') +------------------------------------------+ | unix_timestamp('10/20/2007', 'm/d/yyyy') | +------------------------------------------+ | 1192838400 | +------------------------------------------+

jbapple · ‎10-27-2015

Could be. We're still looking into it.

jbapple · ‎10-27-2015

This is a known issue, but I havent yet seen it without multiple concurent Impala writers. (I have been able to repro it both in the same impalad and in different impalads.) https://issues.cloudera.org/browse/IMPALA-2423 Is there only a single writer using a single impalad at the time?

jbapple · ‎10-26-2015

I asked around, and somebody knew somebody who asked Simba. They said: "There shouldn't be a limitation on the number of rows imposed by the driver, although there is a statement attribute for limiting the number of rows to return (SQL_ATTR_MAX_ROWS). If there are further issues, can you please tell the customer to enable logging through ODBC Administrator and send a zip file of the captured driver logs?"

jbapple · ‎10-23-2015

Maybe you could UseNativeQuery? http://www.simba.com/wp-content/uploads/2014/01/Simba-JDBC-Driver-for-Cloudera-Impala-Install-Guide.pdf See page 35.

Online	Offline
Last Visited	‎08-30-2018 11:50 AM

Date Registered	‎10-20-2015 02:50 PM
Last Visited	‎08-30-2018 11:50 AM
Total Messages Posted	35
Total Kudos Received	5

Re: Invalid Exchange Node Non-Child Time

Re: Integrating Impala with Cloudera resource mana...

Re: Impala c++ udf - does building and deploying r...

Re: Hash join node no-child time is much bigger th...

Re: Partition Spec Does Not Exist error

Re: SFTP from Local server to hdfs

Re: impala-shell ldap login without password

Re: Blank Lines at the beginning of output csv fro...

Re: Blank Lines at the beginning of output csv fro...

Re: "invalidate metadata" do not work

Re: Invalid Exchange Node Non-Child Time

Re: Integrating Impala with Cloudera resource mana...

Re: Partition Spec Does Not Exist error

Re: Impala c++ udf - does building and deploying r...

Re: Hash join node no-child time is much bigger th...

Re: Hash join node no-child time is much bigger th...

Re: Formats for unix_timestamp() function in Impal...

Re: How to find time of last compute stats command...

Re: Formats for unix_timestamp() function in Impal...

Re: Partition Spec Does Not Exist error

Re: Partition Spec Does Not Exist error

Re: ODBC Access from SAP BusinessObjects

Re: Impala Jdbc throws exception where Impala Hue ...