Re: Queries to custom serde return 'NULL' until hiveserver2 restart

Hi all, Thanks for the suggestion Gopal. It turns out the error occurs on both "SELECT *" and "SELECT col" queries. The only sort of query that seems safe are those with aggregations or other things that cause them to be run as mr tasks (e.g. "SELECT SUM(price_f) FROM my_external_table").

Speakers needed for Apache DC Roadshow

We need your help to make the Apache Washington DC Roadshow on Dec 4th a success. What do we need most? Speakers! We're bringing a unique DC flavor to this event by mixing Open Source Software with talks about Apache projects as well as OSS CyberSecurity, OSS in Government and and OSS Career

Re: Not able to read Hive ACID table data created by Hive 2.1.1 in hive 2.3.3

Hi, I tried option 1 mentioned in trail mail and its working but due to this there are different access related tasks which needs to be done. So can anyone reply on point 2 and 3, it will be helpful to understand other possible solution. Regards, Anup Tiwari On Fri, Sep 7, 2018 at 10:15 AM

How to Grant All Privileges for All Databases except one in Hive SQL

Hi All, I have similar requirement as mentioned in the link Link to question . *Requirement :-* I know how to grant privileges on a database to a role in Hive SQL. For example,

Re: Announce: MR3 0.3, and performance comparison with Hive-LLAP, Presto, Spark, Hive on Tez

Thank you for reading the article. I plan to publish the result of running concurrent queries with the release of MR3 0.4 (which implements a feature affecting the performance of concurrent queries). --- Sungwoo On Sat, Sep 8, 2018 at 8:06 AM Nicolas Paris wrote: > > On Thu, Aug 16, 2018 at

Re: Hive generating different DAGs from the same query

Hello Gopal, I have been looking further into this issue, and have found that the non-determinstic behavior of Hive in generating DAGs is actually due to the logic in AggregateStatsCache.findBestMatch() called from AggregateStatsCache.get(), as well as the disproportionate distribution of Nulls