Transpose?pivot rows and columns in hive

Hi , How to Transpose?pivot rows and columns in hive Your help is appreciated. cheers

Hive nested correlated sub queries

Hi Team I need to convert below sql query to hive query. Is nested sub-queries possible in hive? SELECT * FROM( SELECT NVL((SELECT orgname FROM organisations WHERE orgid IN(SELECT parentid FROM organisations WHERE orgid IN(SELECT parentid FROM organisations WHERE orgid IN(SELECT parentid FROM

hive benchmark

Hi Folks, I need to insert 1 billion records into hive and here is my cluster details. 1. 6-node Hadoop cluster cluster. 2. 16GB RAM on each node. 3. 2TB Hard-disk on each node. Is this configuration suitable for storing 1 billion records? If not, what is that all we need

Re: Perl-Hive connection

...@gmail.com wrote: On 29 Jul 2015, at 9:42, siva kumar wrote: Hi folks, I need to set up a connection between perl and hive using thrift. Can anyone sugggest me the steps involved in making this happen?. Thanka and regrads, siva. Hi, check out http://search.cpan.org/~dmor

Perl-Hive connection

Hi folks, I need to set up a connection between perl and hive using thrift. Can anyone sugggest me the steps involved in making this happen?. Thanka and regrads, siva.

Re: Hive Data into a Html Page

What web/application server do you have? You could use Hive or Drill odbc drivers... Sent from my Sony Xperia™ smartphone siva kumar wrote Hi , There is some data loaded into hive and i want to display hive data into a html webpage based on the parameters i pass. So

skewed tables

hi folks, Im working on skewed tables but facing some problems while it has to create seperate files. Here is my query. create table t(key string,value int) row format delimited stored as textfile; load data local inpath 'skew.txt' into table t; select * from t; OK siva

hue not writing data to sql tables

Hi folks, I need to populate hive query history in sql table.Im quering those using hue. My hue default database is sqlite3. When i say '.tables' it displayed me list of tables where i can find auth_user,beeswax_queryhistory tables and many other tables as well. But,when i say

Re: audit hive query

Dev On Fri, Sep 19, 2014 at 4:01 PM, siva kumar siva165...@gmail.com wrote: Hi All, I have a requirement to view the recently executed Hive queries in sql. I have configured sql as metastore to hive and im able to view hive tables,columns,partitions in sql . Simillarly,i need

audit hive query

Hi All, I have a requirement to view the recently executed Hive queries in sql. I have configured sql as metastore to hive and im able to view hive tables,columns,partitions in sql . Simillarly,i need to view the hive queries executed on hive data. Any help is appreciated, sivakumar.c

Inline query in select clause

Hi, I have below 2 tables� 1) create table dim (rank string,grade string) row format delimited fields terminated by ',' stored as textile; Data: 1,1 2,1 3,1 4,2 5,2 6,2 7,3 2) create table fact (rollno string,name string,sub1 string,rank1 string,sub2 string,rank2 string,sub3 string,rank3 string)

Fwd: Inline query in select clause

-- Forwarded message -- From: siva kumar siva165...@gmail.com Date: Mon, Jul 21, 2014 at 3:52 PM Subject: Inline query in select clause To: user@hive.apache.org Hi, I have below 2 tables� 1) create table dim (rank string,grade string) row format delimited fields terminated