@aohl, Thanks for sharing the details about your resolution on the issue. I am glad that it has been resolved and sure others will benefit from your findings here. Cheers Eric ... View more

@gimp077 , When you say you did "REFRESH" the table, did you run "REFRESH <tablename>" or "INVALIDATE METADATA", because those two are not identical in the way they work. Is your table partitioned? If yes, can you see the new partition from Impala by running 'SHOW PARTITIONS <tablename>"? Cheers Eric ... View more

@yukti, I see that there is a new line after UUID in the log, not sure if that is formatting issue on the post or it is there in the log? Can you please double check and also the content in UUID file? Cheers Eric ... View more

Hi Vijay, Sorry, haven't able to nail down the cause yet, but can you collect EXPLAIN EXTENDED of the query and share the output as attachment to the post? EXPLAIN EXTENDED select * from tdb1.t1 where bs1_dt=2017-06-23; EXPLAIN EXTENDED select * from tdb1.t1; I would like to check how HS2 does the query plan and see if there is any clue. Cheers Eric ... View more

I am a bit running out of ideas, but a couple of more questions: 1. what version of CDH are you using? I can't remember if I have asked 2. can you try to remove below directory in HDFS: hdfs://nameservice1/abc/xyz/efg/bs1_dt=__HIVE_DEFAULT_PARTITION__ and also drop the partition on the table against this path, just to make sure that it is clean and try again in in beeline with your problematic query? I remember this might cause issue sometimes, but can't remember which version though, need a bit more digging. Cheers ... View more

Before you try to connect from PyHive, please confirm if you can do so through beeline and make sure HS2 is functioning OK. Again, HS2 port is 10000 based on your config, so you should connect to 10000 from client side. Do you see any errors from HS2 log? Try beeline and what does it say? Cheers ... View more

hive.server2.thrift.port is the one you should connect to, which is 10000, NOT 10002, please try with 10000 port and see how you go. Cheers Eric ... View more

@ranger Did you change HS2's default ports? 10002 by default is HS2's web UI port, the thrift port should be 10000. Can you please check your HS2's hive-site.xml file and confirm the value for hive.server2.thrift.port and hive.server2.webui.port? Thanks Eric ... View more

You can do alter like I mentioned before: ALTER TABLE test CHANGE col1 col1 int COMMENT 'test comment'; But I do not think you can remove it, but rather to just empty it. Cheers Eric ... View more