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

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

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

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

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

@punshi, Have you tried the steps I mentioned in my previous post? Cheers Eric ... View more