unsubscribe

unsubscribe

Re: Local hivemetastore service

Turns out I just had my hive-site configured incorrectly, nvm :p On Thu, Sep 3, 2015 at 10:12 PM, Jerrick Hoang wrote: > Hi all, > > > So I have a machine that has hive installed, the actual hivemetastore > rdbms is installed in a remote machine. I started hive metastore service > locally at por

Limiting with index creation on hive empty tables with tez execution engine

Hi Team, In our environment we have set hive execution to Tez and tried to create/rebuild index on empty tables. Then we found that index creation is not happening. we are getting the below error: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.tez.TezTask. It seems to

Re: Table level stats are not shown after insert starting in Hive 0.13?

Adding Dev user list. Could somebody help take a look? On Thu, Sep 3, 2015 at 12:25 PM, Jim Green wrote: > Also tried Hive 1.0, and the result is the same as Hive 0.13. > Is there any reason why we do not print the table level stats for > partition table? > > On Thu, Sep 3, 2015 at 10:41 AM, Jim

Index creation is failing from beeline when execution engine is set to Tez

Hi Hive Team, In Hive, with execution engine is set to Tez and when we tried to rebuild index on a table (which is not empty) using beeline, index creation is not happening. It is not throwing any error too on to console. But in the corresponding tez job logs we found below error: 2015-08-24 18:0

Error upon XML serialization.

I attempted to serialize a "QueryPlan (ql/QueryPlan.java)" using Utilities.serializePlan() function, and encountered errors (pasted below); I had "hive.plan.serialization.format=javaXML". No such exception was thrown while setting serialization format to "kryo". However, I was not successful in des

Re: Table level stats are not shown after insert starting in Hive 0.13?

Also tried Hive 1.0, and the result is the same as Hive 0.13. Is there any reason why we do not print the table level stats for partition table? On Thu, Sep 3, 2015 at 10:41 AM, Jim Green wrote: > *Hive 0.12:* > After insert SQL: > Partition default.mytablepar{id=111} stats: [num_files: 1, num_r

Subquery in select statement

Hi, There are somthing that I can do this? SELECT tb.id, (SELECT tb3.field FROM database.table2 tb2 JOIN database.table3 tb3 ON ( tb3.id = tb2.table3_id) ORDER BY tb3.date DESC LIMIT 1) AS tb3_field FROM database.table1 tb1 Best, *Daniel Lopes, B.Eng* Data Scientist - BankFacil CREA/SP 5

Re: Request for write access to the Hive wiki

You've got it. Welcome to the Hive wiki team, Aswathy! -- Lefty On Thu, Sep 3, 2015 at 1:21 PM, Aswathy C.S <2aswa...@gmail.com> wrote: > Hi Lefty, > > I have created Confluence account, same username: asreekumar. > Misunderstood Confluence account for apache account. Thanks for the signup > l

Re: ORC NPE while writing stats

Thanks, that should help moving forward On Sep 3, 2015 10:38 AM, "Prasanth Jayachandran" < pjayachand...@hortonworks.com> wrote: > > > On Sep 2, 2015, at 10:57 PM, David Capwell wrote: > > > > So, very quickly looked at the JIRA and I had the following question; > > if you have a pool per thread

Table level stats are not shown after insert starting in Hive 0.13?

*Hive 0.12:* After insert SQL: Partition default.mytablepar{id=111} stats: [num_files: 1, num_rows: 0, total_size: 4, raw_data_size: 0] Table default.mytablepar stats: [num_partitions: 1, num_files: 1, num_rows: 0, total_size: 4, raw_data_size: 0] *Hive 0.13:* After insert SQL: Partition default.m

Re: ORC NPE while writing stats

> On Sep 2, 2015, at 10:57 PM, David Capwell wrote: > > So, very quickly looked at the JIRA and I had the following question; > if you have a pool per thread rather than global, then assuming 50% > heap will cause writer to OOM with multiple threads, which is > different than older (0.14) ORC, c

Re: Hive on Spark

What is the benefit of Hive on Spark if you cannot pre-load data into memory that you know will be queried. On Mon, Aug 31, 2015 at 4:25 PM, Xuefu Zhang wrote: > What you described isn't part of the functionality of Hive on Spark. > Rather, Spark is used here as a general purpose engine similar

Re: Request for write access to the Hive wiki

Hi Lefty, I have created Confluence account, same username: asreekumar. Misunderstood Confluence account for apache account. Thanks for the signup link. Hope you could help me with write access now. Aswathy On Thu, Sep 3, 2015 at 1:30 AM, Lefty Leverenz wrote: > Aswathy, Confluence doesn't rec

Re: Request for write access to the Hive wiki

Aswathy, Confluence doesn't recognize that username (although JIRA does), nor does it recognize your actual name. Did you create the Confluence account here ? -- Lefty On Wed, Sep 2, 2015 at 6:12 PM, Aswathy C.S <2aswa...@gmail.com> wrote: > H

Re: unsubscribe

Sasha, to unsubscribe please send a message to user-unsubscr...@hive.apache.org as described here: Mailing Lists . Thanks. -- Lefty On Thu, Sep 3, 2015 at 2:35 AM, Sasha Ostrikov wrote: > unsubscribe >