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
