Re: how to control hive log location on 0.13?

Thanks, Satish Mittal, I've added that information to the Error Logs section of the Getting Started wiki. -- Lefty On Fri, Jul 18, 2014 at 12:19 AM, Satish Mittal wrote: > You can configure the following

Errors while creating a new table using existing table schema

Hello, I am trying to create a new table using an existing table's schema (existing table name in hive: jobs). However, when I do that it doesn't put the new table (new table name in hive: jobs_ex2) in the same location as the existing table. When I specify the location explicitly, it errors out.

Re: ORC with bloom filters

ORC does not have bloom filters yet. Thanks Prasanth Jayachandran On Jul 17, 2014, at 10:23 PM, Suma Shivaprasad wrote: > Hi, > > I do not see any examples of extending ORC with bloom filters on Hive > documentation. Can someone please explain what exactly needs to be done to > enable this.

Re: External partition table question

Thanks for this clarification. I've revised the Add Partitions section in the wiki accordingly. -- Lefty On Fri, Jul 18, 2014 at 12:45 AM, Satish Mittal wrote: > 'ALTER TABLE .. ADD PARTITION

ORC with bloom filters

Hi, I do not see any examples of extending ORC with bloom filters on Hive documentation. Can someone please explain what exactly needs to be done to enable this. Thanks

Re: External partition table question

'ALTER TABLE .. ADD PARTITION..' would just a partition entry for the table in hive metastore. It doesn't perform any data loading, instead it expects the data to be loaded already in the file pointed to by LOCATION. On Tue, Jul 15, 2014 at 5:39 AM, Raymond Lau wrote: > I've created an external

Re: how to control hive log location on 0.13?

You can configure the following property in $HIVE_HOME/conf/hive-log4j.properties: hive.log.dir= The default value of this property is ${java.io.tmpdir}/${user.name}. Thanks, Satish On Thu, Jul 17, 2014 at 11:58 PM, Yang wrote: > we just moved to hadoop2.0 (HDP2.1 distro). it turns out that

Re: Turning on Tez for Hive

Hi Lefty, I came across those documents as well. They gave me some good hints, but were in some places too specific to Horton Works. For the record, I did get Hive 0.13.1 and Tez 0.4.1 working together. (and I immediately saw a 200% speed up on my corpus of queries). For future travelers here a

Hive XPATH query issue

Hi All, I am trying to parse the below xml file but I am getting invalid expression error.Please help me with this. http://www.w3.org/2001/XMLSchema"; xmlns="http://services.intuit.com/accountant/v1"; targetNamespace="http://services.intuit.com/accountant/v1"; elementFormDefault="qualified" attr

Re: Turning on Tez for Hive

Actually those links don't quite match your component versions. (Close, but they're for Hive 0.13.0 instead of 0.13.1.) The HDP-2.1.3 docs cover Hadoop 2.4.0, Hive 0.1

Re: Turning on Tez for Hive

You might also find useful information in HDP's Hive and HCatalog installation instructions (section 3.1 "Configure Hive and HiveServer2 for Tez") here: http://dev.hortonworks.com.s3.amazonaws.com/HDPDocuments/HDP2/HDP-2.1.2/bk_installing_manually_book/content/rpm-chap6-3.html -- Lefty On Thu,

how to control hive log location on 0.13?

we just moved to hadoop2.0 (HDP2.1 distro). it turns out that the new hive version generates a lot of logs into /tmp/ and is quickly creating the danger of running out of our /tmp/ space. I see these 2 different logs : [myuser@mybox ~]$ ls -lt /tmp/myuser/ total 1988 -rw-rw-r-- 1 myuser myuser

Re: Turning on Tez for Hive

Hi Alex, Thanks for the reply. I should state I am using vanilla apache hadoop 2.4.0 and hive 0.13.1 (not Horton works). And I don't have root access on my pseudo distributed hadoop cluster (single node). I tried your suggestion for a query: hive> explain select count(*) from web_sales; Excep

Re: Hive can I contribute to Hive confluence wiki documents?

Yes, I think. 2014-07-16 14:52 GMT+08:00 Lefty Leverenz : > HIVE-7314 is documented in the Configuration Properties wiki ( > hive.cache.expr.evaluation > ) > and at the b

ERROR in JDBC

Hello Hive Community, I am trying to run the JDBC (from cwiki.apache.org), using HiveServer2. Everything in the Java code (attached above) runs well except for the last query: sql = "select * from " + tableName; Attached is the complete log file of several runs. I have noticed the following er

ERROR in JDBC

Hello Hive Community, I am trying to run the JDBC (from cwiki.apache.org), using HiveServer2. Everything in the Java code (attached above) runs well except for the last query: sql = "select * from " + tableName; Attached is the complete log file of several runs. I have noticed the following er

ERROR in JDBC

Hello Hive Community, I am trying to run the JDBC (from cwiki.apache.org), using HiveServer2. Everything in the Java code (attached above) runs well except for the last query: sql = "select * from " + tableName; Attached is the complete log file of several runs. I have noticed the following er

ERROR in JDBC

Hello Hive Community, I am trying to run the JDBC (from cwiki.apache.org), using HiveServer2. Everything in the Java code (attached above) runs well except for the last query: sql = "select * from " + tableName; Attached is the complete log file of several runs. I have noticed the following er