Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.
jbapple
jbapple
Contributor

Re: SFTP from Local server to hdfs

by Contributor jbapple Contributor in Support Questions
‎06-11-2018 09:55 AM
‎06-11-2018 09:55 AM
Have you tried hadoop distcp? ... View more

Re: impala-shell ldap login without password

by Contributor jbapple Contributor in Support Questions
‎02-09-2017 12:20 PM
‎02-09-2017 12:20 PM
You forgot the echo. ... View more

Re: Impala Insert Overwrite does not update Metada...

by Contributor jbapple Contributor in Support Questions
‎11-10-2016 10:32 PM
1 Kudo
‎11-10-2016 10:32 PM
1 Kudo
1. Correct. 2. Correct. ... View more

Re: Impala Insert Overwrite does not update Metada...

by Contributor jbapple Contributor in Support Questions
‎11-10-2016 06:17 AM
‎11-10-2016 06:17 AM
I think http://www.cloudera.com/documentation/enterprise/latest/topics/impala_sync_ddl.html will answer that question. ... View more

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

by Contributor jbapple Contributor in Support Questions
‎11-02-2016 08:53 AM
‎11-02-2016 08:53 AM
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? ... View more

Re: Impala Insert Overwrite does not update Metada...

by Contributor jbapple Contributor in Support Questions
‎10-26-2016 09:01 PM
‎10-26-2016 09:01 PM
Can you please answer my second question as well? ... View more

Re: Impala Insert Overwrite does not update Metada...

by Contributor jbapple Contributor in Support Questions
‎10-26-2016 11:06 AM
‎10-26-2016 11:06 AM
Can you elaborate on "i can see the data throw browser in the partition"? What do you mean by that?   What do you mean by " when try to fetch the data it return 0"? Do you mean that no rows are returned? ... View more

Re: Correlated subquery gives wrong result back

by Contributor jbapple Contributor in Support Questions
‎10-26-2016 10:33 AM
‎10-26-2016 10:33 AM
This looks like a real bug to me. I'd suggest you file it at issues.cloudera.org. ... View more

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

by Contributor jbapple Contributor in Support Questions
‎10-25-2016 09:07 AM
‎10-25-2016 09:07 AM
What version of Impala?   Does this happen with -q "show databases" instead of -f user.sql? ... View more

Re: "invalidate metadata" do not work

by Contributor jbapple Contributor in Support Questions
‎10-24-2016 10:32 AM
‎10-24-2016 10:32 AM
What do you see if you type "use new_db_from_hive;" into your Impala shell? ... View more

Re: Impala select count(*) returns result, but sel...

by Contributor jbapple Contributor in Support Questions
‎10-20-2016 03:00 PM
1 Kudo
‎10-20-2016 03:00 PM
1 Kudo
You might try asking in a Hive forum ... View more

Re: Impala select count(*) returns result, but sel...

by Contributor jbapple Contributor in Support Questions
‎10-20-2016 02:54 PM
‎10-20-2016 02:54 PM
https://cwiki.apache.org/confluence/display/Hive/AvroSerDe   "Bytes are converted to Array[smallint] prior to Hive 0.12.0." ... View more

Re: raise error on convertion failure instead of n...

by Contributor jbapple Contributor in Support Questions
‎07-26-2016 01:22 PM
‎07-26-2016 01:22 PM
This is not yet possible ... View more

Re: bash shell script with impala queries, possibl...

by Contributor jbapple Contributor in Support Questions
‎07-26-2016 08:40 AM
‎07-26-2016 08:40 AM
Have you tried running 10 at once manually? ... View more

Re: Invalid Exchange Node Non-Child Time

by Contributor jbapple Contributor in Support Questions
‎07-26-2016 07:55 AM
‎07-26-2016 07:55 AM
Can you attach a full profile? ... View more

Re: Integrating Impala with Cloudera resource mana...

by Contributor jbapple Contributor in Support Questions
‎07-24-2016 09:07 AM
‎07-24-2016 09:07 AM
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 ... View more

Re: Partition Spec Does Not Exist error

by Contributor jbapple Contributor in Support Questions
‎06-20-2016 06:35 AM
‎06-20-2016 06:35 AM
You can follow the bug I linked to above for any future updates. Right nowI have no news for you. ... View more

Re: How to find CPU intensive queries in CM

by Contributor jbapple Contributor in Support Questions
‎02-09-2016 09:42 AM
‎02-09-2016 09:42 AM
I think so. If you go to the "Queries" tab, you can enter a query like "thread_cpu_time > 600000.0". ... View more

Re: Impala Column Name convention Issue

by Contributor jbapple Contributor in Support Questions
‎02-05-2016 08:02 AM
‎02-05-2016 08:02 AM
Can you show the command you used in which you "defin[ed] and extract[ed] the records from the table [with] impala" during which it did not show any semantic error? Generally, if a feature (such as numeral-prefixed column names) is unsupported, I would not expect that nothing related to that feature will ever halfway work or just work poorly. I try not to depend on unsupported features working. ... View more

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

by Contributor jbapple Contributor in Support Questions
‎02-05-2016 07:56 AM
‎02-05-2016 07:56 AM
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. ... View more

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

by Contributor jbapple Contributor in Support Questions
‎02-04-2016 12:50 PM
‎02-04-2016 12:50 PM
No, it does not affect the timeline. ... View more

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

by Contributor jbapple Contributor in Support Questions
‎02-04-2016 11:17 AM
1 Kudo
‎02-04-2016 11:17 AM
1 Kudo
This is apperently a bug that has been fixed in more recent versions:   https://issues.cloudera.org/browse/IMPALA-2075 ... View more

Re: Running impala query with inner join

by Contributor jbapple Contributor in Support Questions
‎02-04-2016 09:07 AM
‎02-04-2016 09:07 AM
For the first question, that looks like a bug to me, but I can't reproduce it yet in my recent build. What version are you on? Does it happen without the create table part? Does it happen with straight_join?   For the second question, based on http://www.cloudera.com/documentation/enterprise/latest/topics/impala_create_table.html?scroll=create_table , I believe we do not support that yet. ... View more

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

by Contributor jbapple Contributor in Support Questions
‎02-03-2016 12:34 PM
‎02-03-2016 12:34 PM
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. ... View more

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

by Contributor jbapple Contributor in Support Questions
‎02-03-2016 12:32 PM
‎02-03-2016 12:32 PM
The client itself should tell you, ("Fetched 1 row(s) in 0.31s") or your can run "profile". ... View more

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

by Contributor jbapple Contributor in Support Questions
‎02-03-2016 12:01 PM
1 Kudo
‎02-03-2016 12:01 PM
1 Kudo
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 | +------------------------------------------+ ... View more

Re: UDF missing after Impala restart

by Contributor jbapple Contributor in Support Questions
‎10-27-2015 03:06 PM
‎10-27-2015 03:06 PM
We have no updates to IMPALA-1748 to report at this time. ... View more

Re: Partition Spec Does Not Exist error

by Contributor jbapple Contributor in Support Questions
‎10-27-2015 03:03 PM
‎10-27-2015 03:03 PM
Could be. We're still looking into it. ... View more

Re: Partition Spec Does Not Exist error

by Contributor jbapple Contributor in Support Questions
‎10-27-2015 08:52 AM
‎10-27-2015 08:52 AM
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? ... View more

Re: ODBC Access from SAP BusinessObjects

by Contributor jbapple Contributor in Support Questions
‎10-26-2015 12:55 PM
‎10-26-2015 12:55 PM
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?" ... View more
Contact Me
Online
Offline
Last Visited
‎08-30-2018 11:50 AM
Public Statistics
Date Registered ‎10-20-2015 02:50 PM
Last Visited ‎08-30-2018 11:50 AM
Total Messages Posted 35
Total Kudos Received 5