@Sanaz Janbakhsh Hive CLI is deprecated. We suggest using beeline. There is work being done on a more robust SQL IDE that provides significantly more functionality than the Hive view. ... View more

@tauqeer khan I'd recommend upgrading to 2.6 prior to using LLAP in production. ... View more

Hi @Vinay Khandelwal were you able to find a solution to this problem? This case is a dated but I've recently seen others with similar issues and we are still trying to track down a resolution. ... View more

Check the firewall settings between subnets. The firewall may not be allowing the connection or timing out the connection. ... View more

@Nick Xu Have you generated stats on the table? ... View more

Hi @Nick Xu. _col0 is the first column in the table definition. You can find out what it is by running "DESCRIBE <tablename>" ... View more

Hi @Mushtaq Rizvi, that sounds like a creative and good idea. I'm glad you are working something out that others can learn from. Thanks for posting! ... View more

Hi @Mushtaq Rizvi, in thinking outloud, if you are looking at the Hive metastore and its running Oracle, MySQL, or MariaDB, I supposed you could create standard triggers to notify you when something changes. I know this can be done in SQL Server but I haven't explored the other RBMS options. Be careful how how this would affect performance depending on the rate of change. I'm not aware of a solution native to Hive. Hive does not support triggers though there may be some better options once HPL/SQL is introduced into the Hive. Please update this post if you find another solution. ... View more

Hi @Sebastien F, are you referring to sampling data https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Sampling? I think I need a little more clarification in order to better help. ... View more