Hi Dong Li, I have already seen that question
when I run *hdfs dfs -ls /user/hive/warehouse* I get *Found 5 items drwxrwxr-x - root supergroup 0 2016-04-04 15:00 /user/hive/warehouse/emp drwxrwxr-x - root supergroup 0 2016-04-04 14:40 /user/hive/warehouse/kylin_cal_dt drwxrwxr-x - root supergroup 0 2016-04-04 14:40 /user/hive/warehouse/kylin_category_groupings drwxrwxr-x - root supergroup 0 2016-04-04 14:40 /user/hive/warehouse/kylin_sales drwxrwxr-x - root supergroup 0 2016-04-04 14:52 /user/hive/warehouse/userdb.db* and when I run *hdfs dfs -ls /user/hive/warehouse/kylin_sales* I get *-rw-r--r-- 1 root supergroup 0 2016-04-04 14:40 /user/hive/warehouse/kylin_sales/DEFAULT.KYLIN_SALES.csv* but i have already done *hdfs dfs -chmod 777 /user/hive/warehouse/kylin_sales* *hdfs dfs -chmod 777 /user/hive/warehouse/* Still I am not able to access hdfs through Hive. I am executing all commands as root On Mon, Apr 4, 2016 at 2:51 PM, Dong Li <[email protected]> wrote: > Hello, > > > Please check if your execution user has write permission on hive warehouse > path. > > http://stackoverflow.com/questions/30483296/hadoop-hive-unable-to-move-source-to-destination > > > Thanks, > Dong Li > > > Original Message > Sender:Yagyank [email protected] > Recipient:[email protected] > Date:Monday, Apr 4, 2016 15:54 > Subject:hive hadoop permissions error while using Kylin > > > Hi all, I tried running the sample cube in kylin. But when I try to run > the following command *${KYLIN_HOME}/bin/sample.sh* I get the below output > KYLIN_HOME is set to /usr/lib/kylin Going to create sample tables in > hive... Logging initialized using configuration in > jar:file:/usr/lib/hive/apache-hive-1.2.1-bin/lib/hive-common-1.2.1.jar!/hive-log4j.properties > OK Time taken: 1.924 seconds OK Time taken: 0.502 seconds OK Time taken: > 0.185 seconds OK Time taken: 0.139 seconds OK Time taken: 0.153 seconds OK > Time taken: 0.126 seconds Loading data to table default.kylin_sales Failed > with exception Unable to move source > file:/usr/lib/kylin/sample_cube/data/DEFAULT.KYLIN_SALES.csv to destination > hdfs://localhost:54310/user/hive/warehouse/kylin_sales/DEFAULT.KYLIN_SALES.csv > FAILED: Execution Error, return code 1 from > org.apache.hadoop.hive.ql.exec.MoveTask When I run hadoop fs -ls > /user/hive/warehouse I get the below output *Found 3 itemsdrwxrwxr-x - root > supergroup 0 2016-04-04 13:17 /user/hive/warehouse/kylin_cal_dtdrwxrwxr-x - > root supergroup 0 2016-04-04 13:17 > /user/hive/warehouse/kylin_category_groupingsdrwxrwxr-x - root supergroup 0 > 2016-04-04 13:17 /user/hive/warehouse/kylin_sales* -- Regards *Yagyank > chadha* *Undergraduate student* *Computer Science Engineering* *Thapar > University, Patiala* -- Regards *Yagyank chadha* *Undergraduate student* *Computer Science Engineering* *Thapar University, Patiala*
