Re: Low performance map join when join key types are different

2015-12-23 Thread Zhiwen Sun
Got it. Thanks for your reply. Zhiwen Sun On Wed, Dec 23, 2015 at 2:24 PM, Gopal Vijayaraghavan wrote: > > > But why disable mapjoin has better performance when we don't use cast to > >string(user always lazy)? > > > > Join key values comparison in in reduce stage is more quickly? > > The Ha

Re: Null Representation in Hive tables

2015-12-23 Thread mahender bigdata
Our Files are not text Files, they are csv and dat. Any possibility to include 2 serialization.null format in table property On 12/23/2015 9:16 AM, Edward Capriolo wrote: In text formats the null is accepted as \N. On Wed, Dec 23, 2015 at 12:00 PM, mahender bigdata mailto:mahender.bigd...@out

Re: Null Representation in Hive tables

2015-12-23 Thread Edward Capriolo
In text formats the null is accepted as \N. On Wed, Dec 23, 2015 at 12:00 PM, mahender bigdata < mahender.bigd...@outlook.com> wrote: > Hi, > > Is there any possibility of mentioning both* > "serialization.null.format"="" and **"serialization.null.format"="\000" > *has table properties, current

Null Representation in Hive tables

2015-12-23 Thread mahender bigdata
Hi, Is there any possibility of mentioning both*"serialization.null.format"="" and **"serialization.null.format"="\000" *has table properties, currently we are creating external table, where there is chance of having data with empty string or \000, As a work around, we have created 2 extern

Re: How does this work

2015-12-23 Thread Al Pivonka
Sentry sets up acls (access control list) on those directies, depending on who you granted access to when you established the tables location. Be careful to remove grant permissions when you drop the table or sentry will enforce the acls on the directory tree. Hope this helps On Dec 23, 2015 11:1

Re: troubleshooting: "unread block data' error

2015-12-23 Thread Sofia
Hi Xuefu Zhang, I just tried again Hive with Spark after a long time. When I run queries that do not touch HBase it works fine at cluster mode. The problem occurs when I try to run a query that is on HBase (obviously through Hive) > On 19 Nov 2015, at 20:54, Xuefu Zhang wrote: > > Are you ab

How does this work

2015-12-23 Thread Kumar Jayapal
Hi, My environment has Kerbros and Senry for authentication and authorisation. we have the following permission on drwxrwx--- - hive hive */user/hive/warehouse* Now When I login through Hue/Beeline how am able to acccess the data inside this directory. When I dont belong to hive gr