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