Re: DML operations and transactions in Hive

2015-11-06 Thread Eugene Koifman
https://cwiki.apache.org/confluence/display/Hive/Hive+Transactions describes this in detail Assuming all tables in the query are ACID tables, then reads are consistent. ACID is supported by MVCC architecture at the storage layer (ORC). Locking is at partition level. If one statement is trying t

Re: Utilities.copyTableJobPropertiesToConf

2015-11-06 Thread Carlos Hurtado Larrain
xcscxç m z ć El nov 6, 2015 7:47 PM, "Gabriel Balan" escribió: > Hello, > > May I please get a bit of help understanding the bigger picture for > Utilities.copyTableJobPropertiesToConf() >

Utilities.copyTableJobPropertiesToConf

2015-11-06 Thread Gabriel Balan
Hello, May I please get a bit of help understanding the bigger picture for Utilities.copyTableJobPropertiesToConf() * before hive 0.13

Re: Cross join/cartesian product explanation

2015-11-06 Thread Gopal Vijayaraghavan
> Over the last few week I¹ve been trying to use cross joins/cartesian >products and was wondering why, exactly, this all gets sent to one >reducer. All I¹ve heard or read is that Hive can¹t/doesn¹t parallelize >the job. The hashcode of the shuffle key is 0, since you need to process every row a

Fw: new message

2015-11-06 Thread Debbie Thomas
Hello! New message, please read Debbie Thomas

Fw: new message

2015-11-06 Thread Debbie Thomas
Hello! New message, please read Debbie Thomas

Fw: new message

2015-11-06 Thread Debbie Thomas
Hello! New message, please read Debbie Thomas

Fw: new message

2015-11-06 Thread Nathan Loring
Hello! New message, please read Nathan Loring

Fw: new message

2015-11-06 Thread Nathan Loring
Hello! New message, please read Nathan Loring

Fw: new message

2015-11-06 Thread Nathan Loring
Hello! New message, please read Nathan Loring

Fw: new message

2015-11-06 Thread Jeff Kim Barrett
Hello! New message, please read Jeff Kim Barrett

Fw: new message

2015-11-06 Thread TroopTrack Notifier on behalf of Peter Wojciechowski
Hello! New message, please read TroopTrack Notifier on behalf of Peter Wojciechowski

Fw: new message

2015-11-06 Thread Jon and Teresa Sutcliffe
Hello! New message, please read Jon and Teresa Sutcliffe

Fw: new message

2015-11-06 Thread TroopTrack Notifier on behalf of Peter Wojciechowski
Hello! New message, please read TroopTrack Notifier on behalf of Peter Wojciechowski

Fw: new message

2015-11-06 Thread TroopTrack Notifier on behalf of Peter Wojciechowski
Hello! New message, please read TroopTrack Notifier on behalf of Peter Wojciechowski

Fw: new message

2015-11-06 Thread Rob Cooley
Hello! New message, please read Rob Cooley

Fw: new message

2015-11-06 Thread Soumya Banerjee
Hello! New message, please read Soumya Banerjee

Fw: new message

2015-11-06 Thread Lars George
Hello! New message, please read Lars George

Fw: new message

2015-11-06 Thread Patricia Giraudo
Hello! New message, please read Patricia Giraudo

Fw: new message

2015-11-06 Thread Craig
Hello! New message, please read Craig

Fw: new message

2015-11-06 Thread Mike DeDecker
Hello! New message, please read Mike DeDecker --- Este email foi escaneado pelo Avast antivírus. https://www.avast.com/antivirus

Fw: new message

2015-11-06 Thread Mike DeDecker
Hello! New message, please read Mike DeDecker --- Este email foi escaneado pelo Avast antivírus. https://www.avast.com/antivirus

Fw: new message

2015-11-06 Thread Mike DeDecker
Hello! New message, please read Mike DeDecker --- Este email foi escaneado pelo Avast antivírus. https://www.avast.com/antivirus

Fw: new message

2015-11-06 Thread Ravi Phulari
Hello! New message, please read Ravi Phulari

Fw: new message

2015-11-06 Thread Ravi Phulari
Hello! New message, please read Ravi Phulari

Fw: new message

2015-11-06 Thread FedEx . com Online Services
Hello! New message, please read FedEx.com Online Services

Fw: new message

2015-11-06 Thread FedEx . com Online Services
Hello! New message, please read FedEx.com Online Services

Cross join/cartesian product explanation

2015-11-06 Thread Rory Sawyer
Hi all, Over the last few week I’ve been trying to use cross joins/cartesian products and was wondering why, exactly, this all gets sent to one reducer. All I’ve heard or read is that Hive can’t/doesn’t parallelize the job. Is there some code people can point me to? Does anyone have a workaroun

DML operations and transactions in Hive

2015-11-06 Thread Ashok Kumar
Hi, I would like to understand a bit more about insert/update/select operations in Hive. I believe ORC table format offers the best performance and concurrency. Is ORC the best format for DML operations. What is the granularity of locks? Is it partition or row. Also how ACID properties implement

Re: How to set add jar jarpath within hive jdbc query?

2015-11-06 Thread Lee S
Put jar in lib or on hdfs both works. And also indicates a local path on hiveserver host works, too. But, the path needs to under the user hive. p.s How to change the default user hive when I connect to hive server ? On Thu, Nov 5, 2015 at 10:33 PM, Chetna C wrote: > You can move your auxili