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 '*'
> >
> >
>
