Member since
03-23-2015
1288
Posts
114
Kudos Received
98
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
2496 | 06-11-2020 02:45 PM | |
4024 | 05-01-2020 12:23 AM | |
2109 | 04-21-2020 03:38 PM | |
2075 | 04-14-2020 12:26 AM | |
1706 | 02-27-2020 05:51 PM |
07-15-2019
03:31 AM
Hi Wert , From what I can see, Impala does not use class org.antlr.runtime.CharStream directly, but Hive does, I am wondering what are the errors you can find from Catalogd and HiveMetaStore server logs? Just to confirm if the issue is really coming from Hive? Also, what version of CDH are you using? Is it only affecting 1 out of 3 hosts? How do you install CDH? Through CM or manual process? Cheers Eric
... View more
07-15-2019
03:12 AM
1 Kudo
Hi, I do not think there is any different. Spark lazily executes statements, so you second 2 jobs version will behave the same way as the first single job, in my opinion. Cheers Eric
... View more
07-11-2019
05:36 PM
Hi Michael, Thanks for the info. I am curious on whether 2.6.1 version will work or not? 2.6.4 is marked as C6 compatible, I am not sure if that is meant for C6 or not. Cheers Eric
... View more
07-10-2019
04:48 PM
Hi, It looks like that you have set configuration hive.query.redaction.rules somewhere, though I can't see it from the command you ran. Couple of things to check: 1. run "which beeline" to confirm that you are running original beeline command, not a custom one 2. check under ~/.beeline directory to see if there is any user level files that might override the default settings 3. use different users to run beeline to see if there is any differences. Thanks Eric
... View more
07-04-2019
10:03 PM
Hi Mike, Try to add LogPath=/path/to/dir and LogLevel=6 in ODBC configuration to enable TRACE logging and see what might be shown in the ODBC trace logs. Please share the output once collected. Cheers Eric
... View more
07-04-2019
10:01 PM
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
07-04-2019
09:55 PM
1 Kudo
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
07-04-2019
09:26 PM
Hi, This behaviour is weird. However, to understand more, is it possible that you can create a simple use case to re-produce the issue? What version of Impala/CDH are you using? Cheers Eric
... View more
06-26-2019
12:01 AM
You can only load one partition at a time if you want to use LOAD DAAT command, and the underlining file should not have the data for the partition column. So in your case, your data is: 2,2009 10,2009 15,2010 34,2010 So you should create 2 files, and each with below content: 2009.txt 2 10 2010.txt 15 24 Then load then individually: load data inpath '/user/impala/data/2009.txt' into table tbl_id_part partition(year=2009); load data inpath '/user/impala/data/2010.txt' into table tbl_id_part partition(year=2010); Hope above helps. Cheers Eric
... View more
06-25-2019
11:58 PM
@punshi, Have you tried the steps I mentioned in my previous post? Cheers Eric
... View more