Thanks that seems to work. -ray
On Wed, Jul 22, 2009 at 2:10 PM, Zheng Shao <[email protected]> wrote: > HI Ray, > > This error usually happens if Hive.g is updated but "ant clean" is not > run before "ant package". > > Can you try "ant clean" and rebuild the code? > > Zheng > > On Mon, Jul 20, 2009 at 7:57 AM, Ray Duong<[email protected]> wrote: > > Hi Tim, > > > > I'm still getting an error, when specifying the column names. > > > > > > hive> describe extended pokes; > > OK > > foo int > > bar string > > Detailed Table Information: > > > Table(tableName:pokes,dbName:default,owner:root,createTime:1248099183,lastAccessTime:0,retention:0,sd:StorageDescriptor(cols:[FieldSchema(name:foo,type:int,comment:null), > > > FieldSchema(name:bar,type:string,comment:null)],location:/user/hive/warehouse/pokes,inputFormat:org.apache.hadoop.mapred.TextInputFormat,outputFormat:org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat,compressed:false,numBuckets:-1,serdeInfo:SerDeInfo(name:null,serializationLib:org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe,parameters:{serialization.format=1}),bucketCols:[],sortCols:[],parameters:{}),partitionKeys:[],parameters:{SORTBUCKETCOLSPREFIX=TRUE}) > > Time taken: 0.165 seconds > > > > hive> select foo, bar from pokes; > > FAILED: Parse Error: line 1:7 cannot recognize input 'foo' > > > > Time taken: 0.0090 seconds > > > > Thanks, > > -ray > > > > On Mon, Jul 20, 2009 at 7:42 AM, tim robertson < > [email protected]> > > wrote: > >> > >> Can you please try > >> > >> select foo,bar from pokes; > >> > >> ? > >> > >> > >> > >> On Mon, Jul 20, 2009 at 4:25 PM, Ray Duong<[email protected]> wrote: > >> > Hi Hive Users. > >> > > >> > I'm a newbie to hive so this might be a dumb configuration issue. I > am > >> > trying to run Hive on Amazon EC2 and getting an error when attempting > to > >> > follow the sample script from the Hive wiki site. I'm able to create > >> > and > >> > load the data but not able to read the content of the file. Was there > a > >> > step that I missed during the Hive startup? > >> > > >> > Thanks, > >> > -ray > >> > > >> > > >> > Logging in to host ec2-75-101-208-214.compute-1.amazonaws.com. > >> > > >> > __| __|_ ) Fedora 8 > >> > _| ( / 32-bit > >> > ___|\___|___| > >> > > >> > Welcome to an EC2 Public Image > >> > :-) > >> > Base > >> > > >> > [r...@domu-12-31-39-00-89-56 ~]# ls > >> > ec2-ami-tools-1.3-19974.noarch.rpm > >> > > >> > cd /usr/local/hadoop-0.19.0/contrib/hive > >> > > >> > [r...@domu-12-31-39-00-89-56 hive]# bin/hive > >> > > >> > hive> CREATE TABLE pokes (foo INT, bar STRING); > >> > OK > >> > Time taken: 12.545 seconds > >> > hive> CREATE TABLE invites (foo INT, bar STRING) PARTITIONED BY (ds > >> > STRING); > >> > OK > >> > Time taken: 0.129 seconds > >> > hive> LOAD DATA LOCAL INPATH './examples/files/kv1.txt' OVERWRITE INTO > >> > TABLE > >> > pokes; > >> > Copying data from > >> > file:/usr/local/hadoop-0.19.0/contrib/hive/examples/files/kv1.txt > >> > Loading data to table pokes > >> > OK > >> > Time taken: 1.963 seconds > >> > hive> select * from pokes; > >> > FAILED: Parse Error: line 1:7 cannot recognize input '*' > >> > > >> > > > > > > > > > -- > Yours, > Zheng >
