Insert data into hive table

You can insert new data into table by two ways.

1. Load the data of a file into table using load command.

   LOAD DATA [LOCAL] INPATH 'filepath' [OVERWRITE] INTO TABLE tablename.

2. You can insert new data into table by using select query.

   INSERT INTO table tablename1 select columnlist FROM secondtable;

If you already have a table pre_loaded_tbl with some data. You can use a trick to load the data into your table with following query

INSERT INTO TABLE tweet_table   SELECT  "my_data" AS my_column     FROM   pre_loaded_tbl    LIMIT   5;

Also please note that "my_data" is independent of any data in the pre_loaded_tbl. You can select any data and write any column name (here my_data and my_column). Hive does not require it to have same column name. However structure of select statement should be same as that of your tweet_table. You can use limit to determine how many times you can insert into the tweet_table.

However if you haven't' created any table, you will have to load the data using file copy or load data commands in above answers.

Try to use this with single quotes in data:

insert into table test_hive values ('1','puneet');