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