Re: Hi,all.Is it possible to generate mutiple records in one SerDe?

2011-03-21 Thread
Wow, is there any other way to do that? 2011/3/21 Ted Yu > I don't think so: > Object deserialize(Writable blob) throws SerDeException; > > > > On Mon, Mar 21, 2011 at 4:55 AM, 幻 wrote: > >> Hi,all.Is it possible to generate mutiple records in one SerDe? I mean if >> I can return more than on

Re: Dynamic Configuration support in Hive SQL

2011-03-21 Thread Avram Aelony
You can probably do this in Bash now, try something like this: zz=`hive -S -e "select count(1) from t"` ~Avram ~ Avram Aelony|Sr. Analyst|eHarmony.com|(424) 258-1199|x1098|skype: avram.aelony ~ On Mar 21, 2011, at 3:55 PM, Sameer Kalburgi wrote: > Any plans, if possible, to allow you to se

Create Table Error

2011-03-21 Thread Anja Gruenheid
Hi! I've tried to run a create table statement via the HiveCLI in Eclipse and it fails with the following exception: FAILED: Error in metadata: MetaException(message:Got exception: java.io.FileNotFoundException File file:/user/hive/warehouse/customer does not exist.) 11/03/21 19:05:36 ERROR ex

Re: Dynamic Configuration support in Hive SQL

2011-03-21 Thread Sameer Kalburgi
Any plans, if possible, to allow you to set the variable from a query result e.g. 'set zzz = (select count(1) from t)'? On Mon, Mar 21, 2011 at 5:20 PM, Edward Capriolo wrote: > On Mon, Mar 21, 2011 at 11:43 AM, Andrew Wilson > wrote: > > We use the Cloudera Oozie distro which has a Hive action

Re: Dynamic Configuration support in Hive SQL

2011-03-21 Thread Edward Capriolo
On Mon, Mar 21, 2011 at 11:43 AM, Andrew Wilson wrote: > We use the Cloudera Oozie distro which has a Hive action, and provides that > kind of template support for Hive scripts. > > On Mar 21, 2011, at 11:35 AM, Lenin Gali wrote: > >> Best way to do this is to write shell or python scripts and e

RE: Problems with MetaStore

2011-03-21 Thread Christopher, Pat
That message is saying, 'found all drivers, trying to connect to specified metastore db. Can't'. Check the following: - MySQL/Derby server running - correct ip/hostname specified (I've had troubles with dynamic ips) - userid/pwd exists on server and has correct grants - will need creat

Re: Dynamic Configuration support in Hive SQL

2011-03-21 Thread Andrew Wilson
We use the Cloudera Oozie distro which has a Hive action, and provides that kind of template support for Hive scripts. On Mar 21, 2011, at 11:35 AM, Lenin Gali wrote: > Best way to do this is to write shell or python scripts and echo with > substitute variables and call hive from command line p

Re: Dynamic Configuration support in Hive SQL

2011-03-21 Thread Lenin Gali
Best way to do this is to write shell or python scripts and echo with substitute variables and call hive from command line passing -f argument with output file. Lenin Sent from my BlackBerry® wireless handheld -Original Message- From: amit jaiswal Date: Mon, 21 Mar 2011 08:10:55 To:

Dynamic Configuration support in Hive SQL

2011-03-21 Thread amit jaiswal
Hi, Does hive support dynamic configuration? For example: is it possible to write a hive script with some ${PARAM} variables and let hive replace these parameters with their values at runtime. Eg. Original hive script: select * from person where age > ${MIN_AGE}; Config file: MIN_AGE=18 And h

Re: Hi,all.Is it possible to generate mutiple records in one SerDe?

2011-03-21 Thread Ted Yu
I don't think so: Object deserialize(Writable blob) throws SerDeException; On Mon, Mar 21, 2011 at 4:55 AM, 幻 wrote: > Hi,all.Is it possible to generate mutiple records in one SerDe? I mean if I > can return more than one rows in deserialize? > > Thanks! >

Wrong file format error

2011-03-21 Thread abhishek pathak
Hi all, I have created an external hive table with the STORED AS SEQUENCEFILE option.However,when I try to load a blank file into that table it gives me the following error: Failed with exception Wrong file format. Please check the file's format. FAILED: Execution Error, return code 1 from org