Re: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. org/apache/hadoop/hbase/HBaseConfiguration

2014-02-11 Thread dwivedishashwat
Is your huve able to connect to hadoop Try putting hadoop and hive configuration files in hive conf dir Sent from Samsung Mobile Original message From: Josh Draner Date: 12/02/2014 08:35 (GMT+05:30) To: user@hive.apache.org Subject: FAILED: Execution Error, return co

FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. org/apache/hadoop/hbase/HBaseConfiguration

2014-02-11 Thread Josh Draner
Hi, I have been unsuccessful trying to setup Hive 0.12 with HBase 0.96.1.1. I am able to get both Hive and HBase to work independently of each other, but when I attempt to map a Hive table to an HBase table I am greeted with: hive> CREATE TABLE foo(rowkey INT, name STRING) > STORED BY 'org.a

Sampling from a single column

2014-02-11 Thread Oliver Keyes
Hey all So, what I'm looking to do is get N randomly-sampled distinct values from a column in a table. I'm kind of flummoxed by how to do this without using TABLESAMPLE, which would require me to add Yet Another Subquery (it'd be 'select these values, from this sample, from these distinct values')

Re: Views and partitions and performance

2014-02-11 Thread Stephen Sprague
great questions, Burak. Personally, I had not before seen the "create view ... partition on" construct. Not that that means anything but thanks for bringing bringing out into the forefront! So, yeah, do we have an SME out there that would like to elaborate on this beyond the aforementioned url?

Re: Configuring Apache Hive using Kerberos Authentication

2014-02-11 Thread Prasad Mujumdar
If you are talking about embedded Hive client (CLI), then all you need is to have a TGT in the ticket cache (ie run kinit before invoking Hive). The underlying hadoop client handles communication with secure Hadoop services. As long as the Hadoop related security configuration is place, there's

Partition column on an Alpha Numeric Column

2014-02-11 Thread Raj Hadoop
All, One of the primary key columns in a Relational table has alpha numberic of 6 characters - varchar(6). The first three characters has this pattern - 1st one - 1 to 9    2nd one - 1 to 9 or a -z 3rd one - 1 to 9 or a -z Is this a good idea for performing queries ( can be any queries based

Views and partitions and performance

2014-02-11 Thread Burak Gürsoy
Hi, Some background information: We have a really large base table (~1P) — (lets call it raw_table) partitioned like _mm_dd=2014-02-11/hh=12/flag=1 (or _mm_dd=2014-02-11/hh=12/flag=0) I’m testing creating a view on that table to be able to have a consistent user accessible interface ins

Re: FUNCTION HIVE to DAYS OF WEEK

2014-02-11 Thread John Meagher
The pom.xml file in the top level specifies the version of Hadoop and Hive it is compiling against. There are 2 ways to get things working: 1) Modify the HiveSwarm pom.xml file to reference the version of Hadoop and Hive you are using and recompile 2) Copy the day of the week UDF over into your ow

Re: FUNCTION HIVE to DAYS OF WEEK

2014-02-11 Thread Eduardo Parra Valdes | BEEVA
Hi, Jhon Thank very much for your response. this project is very interesting. I test your jar , but no work. I think that is because i have other version of hadoop. I have installed Hadoop 2.2.0 whit YARN. the Error is Diagnostic Messages for this Task: Error: java.lang.RuntimeException: Error

Configuring Apache Hive using Kerberos Authentication

2014-02-11 Thread Anilkumar Kalshetti
Hello, Has anyone implemented Kerberos authentication for Apache Hive? Kerberos authentication for Hadoop is documented very well, and I am able to do it. Connecting databases like MongoDb, PostgreSQL using kerberos auth. is quite straight-forward, But there are missing links in documentation, wh