Using a Cygwin distribution, I've installed Hadoop 0.20.3 and Hive 0.11.0.
First of all, I don't understand how to use the Hive CLI:
hive> show tables;
Then enter and nothing happens. I can execute queries using hive -e/-f.
Then, I've created a table:
CREATE TABLE tweet_table(
tweet STRING
)
COMMENT 'Table of string'
But how can I insert data into this table? I see some INSERT INTO
examples but when I try:
INSERT INTO TABLE tweet_table (tweet) VALUES ("data")
I've got an error:
FAILED: ParseException line 1:30 cannot recognize input near '(' 'tweet' ')' in select clause
How can I append data in my table?