LDAPS (Secure LDAP) Hive configuration

Hello, We are working on a Hive 2.0.0 cluster, to configure LDAPS authentication, but I get some errors preventing a successful authentication. Does anyone have some insight on how to solve this? *The problem* The errors we get are (first is most frequent): - sun.security.provider.certpath.SunCer

Re: Hive Table Creation failure on Postgres

Right so mysql and oracle both set the column to 256 bytes. Any postgres users who have seen the issue. HIVE-4921 jira talks about upgrading comments column to 4000 for 3 tables. Is than inconsistenty/bug with postgres schema creation script or i

Re: Get 100 items in Comma Separated strings from Hive Column.

Thanks Dudu. This is wonderful explaination. I'm very thankful On 6/10/2016 7:24 AM, Markovitz, Dudu wrote: regexp_extract ('(,?[^,]*){0,10}',0) (...){0,10} The expression surrounded by brackets repeats 0 to 10 times. (,?[…]*) Optional comma followed by sequence (0 or more) of characters [^

Re: NPE while querying timestamp data type in ORC tables

Hi Sharath Glad that it worked. From HIVE-10592 you just need the changes from ColumnStatisticsImpl.java, rest of the patch is irrelevant for this issue. Thanks Prasanth _ From: Sharath Babu Basavaraja mailto:sharathfe...@gmail.com>> Sent: Friday, June 10, 2016 10:3

Re: NPE while querying timestamp data type in ORC tables

Thanks Prasanth. The work-around which you suggested worked for me. But since the table is pretty huge, this seems to have a performance issues on the query time. Can I try applying this patch to fix this issue as provided in JIRA-10592. Regards, Sharath On 8 June 2016 at 16:18, Prasanth Jayacha

RE: Get 100 items in Comma Separated strings from Hive Column.

regexp_extract ('(,?[^,]*){0,10}',0) (...){0,10} The expression surrounded by brackets repeats 0 to 10 times. (,?[…]*) Optional comma followed by sequence (0 or more) of characters [^,] Any character which is not comma regexp_extract (...,0) 0 stands for the whole expression 1 stands for

Re: Get 100 items in Comma Separated strings from Hive Column.

Thanks Dudu. I will check. Can you please throw some light on regexp_replace (((,?[^,]*){0,10}).*','$1') regexp_extract ('(,?[^,]*){0,10}',0), On 6/9/2016 11:33 PM, Markovitz, Dudu wrote: + Improvement The “Count” can be done in a cleaner way (The previous way works also with simple ‘replace’)