Loading data into a table

hive dbvisualizer
RAVITEJA SATYAVADA picture RAVITEJA SATYAVADA · Feb 15, 2013 · Viewed 31.6k times · Source

I'm new to Hive and using DBVisualizer for hive

I have a text file in the path *D:\data files\datafiles*. I want to load data from one of the files to a table created in hive. while i'm trying the following,

load data inpath "D:\data files\sample.txt" into table sample;

It is showing error like,

 cause: FAILED: Error in semantic analysis: Line 1:17 Invalid path "D:\data files\sample.txt": only "file" or "hdfs" file systems accepted

How can proceed, to place that file in correct path and where to place it??

Answer

Balaswamy Vaddeman picture Balaswamy Vaddeman · Feb 16, 2013

either you can upload that file into hdfs and try same command with hdfs path.

or

you may use local keyword as below.

load data local inpath "D:\data files\sample.txt" into table sample;

check this for more details

Related questions

How to delete and update a record in Hive

I have installed Hadoop, Hive, Hive JDBC. which are running fine for me. But I still have a problem. How to delete or update a single record using Hive because delete or update command of MySQL is not working in …

Read More
How to know Hive and Hadoop versions from command prompt?

How can I find which Hive version I am using from the command prompt. Below is the details- I am using Putty to connect to hive table and access records in the tables. So what I did is- I opened …

Read More
Hive insert query like SQL

I am new to hive, and want to know if there is anyway to insert data into hive table like we do in SQL. I want to insert my data into hive like INSERT INTO tablename VALUES (value1,value2..) I …

Read More