Hi All, I am also facing the same issue. I am logged into Ambari with admin user and trying to create /move files from /to under /user/root/satish/ . Here are the details on the folder permissions. [root@sandbox sat]# hadoop fs -ls /user/root/satish/Found 3 itemsdrwxr-xr-x - root hdfs0 2017-06-14 00:54 /user/root/satish/inputdrwxr-xr-x - root hdfs0 2017-06-14 00:55 /user/root/satish/outputdrwxr-xr-x - root hdfs0 2017-06-14 00:55 /user/root/satish/scripts Even I tried with different path too, i am getting the same error. Please let me know if I am missing anything here. Error: java.sql.SQLException: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask ... View more

when we override the path, it won't create any <dbname>.db folder, assuming that the specified path it self is the db /main folder for the mentioned database. ... View more

@Girish Chaudhari Note, when you change the location of the file by using alter command, the old data file is not moved to new location. On your issue, 1) do you have any data files in the mentioned path? 2) Did you get any warnings / errors while you executed this ALTER command? ... View more

When I create a database without passing the location, then it will create that database in default location with <dbname>/db ex: hive> CREATE DATABASE Override1; OK Time taken: 0.06 seconds it will create a Override1.db folder in the default path as [cloudera@quickstart ~]$ hadoop fs -ls /user/hive/warehouse Found 1item drwxrwxrwx - cloudera supergroup 0 2017-06-09 14:46 /user/hive/warehouse/override1.db [cloudera@quickstart ~]$ why don't it it creates folder with <dbname>.db folder  when you pass the location to create a database(overriding the default path) ? ... View more

Good to know this. ... View more

Hi, Could anyone please let me know on this? Thanks. ... View more

@Benjamin Hopp Looks like it's a bug, because the Char always fixed length. In this case you have declared it as char(10), even though you have only 3 chars assigned it to, it should not truncate the rest. ... View more

@Pooja Chawda Here my question is, It should create the <dbname>.db folder (as it does in default path), why It's not creating the <dbname>.db folder when I pass /override the default location? There supposed to be Testing.db under the testing folder right (in your case)? It's strange behaviour when you override the database default path. ... View more

@ozac Can you try without renaming the directory from a1 to a2? Create a separate directory with name as a2 and then alter the table. ... View more