Hi @avengers, The error does not seem to be related to the UDF you used, as there is no reference to it from the error message. Have you tried to run other queries to confirm? Is there other exception error messages in the application log to indicate why this particular executor failed to run the job? Cheers Eric ... View more

Hi @Sidhartha, The error means that the destination table base.customers already has the partition source_name=ORACLE, as the error indicated: Partition already exists [customers(source_name=ORACLE)] Can you run : SHOW PARTITIONS base.customers; to confirm? If yes, try to drop it and then run EXCHANGE PARTITION again. Cheers Eric ... View more

Hi @Mogiking Hue keeps the query handler open so that it can get back to its result during pagination. This is a feature in Hue, not a bug. You can find that info from impala PROFILE under Query Timeline section, like below: Query Timeline Query submitted: 0ns (0) Planning finished: 170ms (170000854) Submit for admission: 172ms (172000864) Completed admission: 172ms (172000864) Ready to start on 2 backends: 172ms (172000864) All 2 execution backends (3 fragment instances) started: 176ms (176000884) Rows available: 422ms (422002119) First row fetched: 501ms (501002515) Unregister query: 509ms (509002555) You can see detailed information on when data is available. Cheers Eric ... View more

Hi Steve, Have you tried below format: jdbc:hive2://hs2node:10000/default;user=<userid>;password=<password> together with other parameters? Thanks Eric ... View more

Hi Tomas, This message is normal behaviour and expected to happen when the Datanode's security key manager rolls its keys. It will cause clients to print this whenever they use the older cached keys, but the post-action of printing this message is that the client refetches the new key and the job completes. Since Impala is a client of HDFS, there is no concern or worry about this message, as it is part of normal operation. We also see this from HBase logs, which is again, normal. Hope above helps. Cheers Eric ... View more

Hi, I am seeing CancelOperation: HardyTCLIServiceThreadSafeClient::CancelOperation Have you checked on the HS2 log to see if anything useful from server side? It does not make sense that SELECT works but INSERT will get timeout, there is no separate configuration for them. What about CTAS query? Cheers Eric ... View more

I don't see super easy way, but below might help: 1. if this table is not external, make it external first: ALTER TABLE <table> SET TBLPROPERTIES('EXTERNAL'='TRUE') 2. drop the table 3. create a new table and define same partition column 4. manually move files in another 4 partition directories into the 6 partition directories that you want to keep evenly 5. remove the empty directories under the table 6. msck repair table to recover the 6 current partitions Hope above can help. Eric ... View more