Loading data into hive


How can i load table with data from /public/retail_db/orders. i have access to gw03 and my user id is shalinisarathykc


Hii @shalinisarathykc

We cannot load the data through /public/retail_db/orders but we can load the data through /data/retail_db/orders by using local inpath

Here is the command you can try

load data local inpath ‘/data/retail_db/orders’ into table orders;

For more information about Loading data into hive, you can go through this page