Re: Parsing Hive Query to get table names and column names

btw, what error are you getting with ANTLR or HiveParser? If any dependency class file is missing? Thanks Alok On Thu, Nov 6, 2014 at 12:59 PM, Alok Kumar wrote: > As Devopam suggested, do it right way from the start. > > PS : if queries are written manually, you could get tables too

Re: Parsing Hive Query to get table names and column names

o do this will be >> to parse the query. >> Isn't Hive somewhat different from SQL? I have already tried using >> JsqlParser but for some cases it doesn't works. >> >> Thanks, >> Regards, >> Ritesh >> >> On Wed, Nov 5, 2014 at 6:05 PM,

Re: Parsing Hive Query to get table names and column names

from here to extract the table names and column > names?* > *And, Is the way I am doing it correct?* > > Thank You. > Regards, > Ritesh > > -- Alok Kumar http://sharepointorange.blogspot.in/

Re: dfs storage full on all slave machines of 6 machine hive cluster

ch > slave node . > > Thanks, > Chunky. > > > > On Mon, Mar 18, 2013 at 10:16 PM, Alok Kumar wrote: > >> Look into your hdfs-site.xml & mapred-site.xml conf files. >> >> *dfs.data.dir* propety contain your actual HDFS data path, better avoid >> deletin

Re: dfs storage full on all slave machines of 6 machine hive cluster

folders with names "subdir0", >>> "subdir1", etc and under them there are many files with name like >>> "blk_-4071357924681234567" and blk_-4071357924681234567_246813.meta:, etc. >>> >>> I want to delete these subdir folders but I am not sure if it will not >>> affects the tables which I have created. >>> >>> Can anyone help me and tell me what are these folders used for ?. >>> >>> Thanks, >>> Chunky. >>> >> >> > -- Alok Kumar

Re: alter external table location with new namenode address

onfluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-AlterTable%2FPartitionLocation > > Thanks. > > Carl > > On Fri, Aug 24, 2012 at 10:56 AM, Alok Kumar wrote: >> >> Bejoy, >> >> Thank you for your help. >> updated metastore n its working fine.

Re: alter external table location with new namenode address

lease excuse typos. > > -Original Message- > From: Alok Kumar > Date: Fri, 24 Aug 2012 13:30:36 > To: ; > Reply-To: user@hive.apache.org > Subject: alter external table location with new namenode address > > Hello, > > We have hive external table mapped to hbase, now mo

alter external table location with new namenode address

Hello, We have hive external table mapped to hbase, now moving from pseudo distributed to fully distributed hadoop cluster. found that hive queries are still pointing to older namenode address ie: hdfs://localhost:9000/user/hive/warehouse/ as it stores full uri in its derby metastore. Q . what w

Re: Hive-Hbase integration require Hbase in Pseudo distributed??

th > $HIVE_HOME/lib/hive-hbase-handler-*.jar,$HIVE_HOME/lib/hbase-*.jar,$HIVE_HOME/lib/zookeeper-*.jar > -hiveconf hbase.master=127.0.0.1:6 > > If no then used above command. > Regards, > Ankit > > > On Fri, Dec 2, 2011 at 5:34 PM, Alok Kumar

Re: Hive-Hbase integration require Hbase in Pseudo distributed??

at org.apache.hadoop.hbase.client.HBaseAdmin.(HBaseAdmin.java:83) Regards, Alok On Fri, Dec 2, 2011 at 5:14 PM, Ankit Jain wrote: > HI, > > Can you post the Hbase-site.xml and hadoop core-site.xml properties here. > > Regards, > Ankit > > > On Fri, Dec 2, 2011 at

Re: Hive-Hbase integration require Hbase in Pseudo distributed??

return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask On Fri, Dec 2, 2011 at 2:03 PM, Ankit Jain wrote: > I think your hbase master is not running. > > Open the hive shell and run command : > hbase> status > > > > On Fri, Dec 2, 2011 at 2:00 PM, Alok Kumar wrote:

Hive-Hbase integration require Hbase in Pseudo distributed??

rom org.apache.hadoop.hive.ql.exec.DDLTask where i shuld look for fixing "*message:org.apache.hadoop.hbase.MasterNotRunningException: localhost:56848*" ..? -- regards Alok Kumar

Fwd: what changes required in hive conf xml when working with hive jdbc

-- Forwarded message -- From: Alok Kumar Date: Thu, Nov 24, 2011 at 7:18 PM Subject: Re: what changes required in hive conf xml when working with hive jdbc To: Vikas Srivastava Hi, Its working fine at $hive shell. No error, Able to create tables... I'm trying to connect

Re: what changes required in hive conf xml when working with hive jdbc

HiveClient >> >> https://cwiki.apache.org/confluence/display/Hive/HiveJDBCInterface >> >> https://cwiki.apache.org/confluence/display/Hive/Home >> >> >> On Thu, Nov 24, 2011 at 3:37 PM, Alok Kumar wrote: >> >>> >>> Hi, >>

what changes required in hive conf xml when working with hive jdbc

Hi, Do I need to make any change in hive configuration file when working with hive-jdbc? I'm trying to configure Hive Jdbc following this link https://cwiki.apache.org/confluence/display/Hive/HiveClient. hive is up n running. I'm able