Support Questions
Find answers, ask questions, and share your expertise

Hive metastore complains about illegal character in path while creating table whereas the path doesnt exist

New Contributor


Whenever I am trying to create any external table with any path, the error comes up


FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:Illegal character in path at index 17: hdfs://namenode1/ apps/sysDSPPRS)


Don't know from where it is taking the space between "namenode1/" and "apps".



hive> CREATE EXTERNAL TABLE mydb.ext_apps (a string, b string) LOCATION 'hdfs://namenode1/apps/sysDSPPRS/sysuser/ext_apps';


There is no path in HDFS as "hdfs://namenode1/ apps", but "hdfs://namenode1/apps" does exist


[sysuser@server dev]$ hadoop fs -ls /
Found 5 items
drwxrwxrwx   - hdfs  supergroup          0 2022-03-04 09:15 /apps
drwx--x--x   - hbase hbase               0 2022-02-02 17:33 /hbase
drwxr-xr-x   - hdfs  supergroup          0 2020-09-18 12:57 /system
drwxrwxrwt   - hdfs  supergroup          0 2022-03-11 07:29 /tmp
drwxr-xr-x   - hdfs  supergroup          0 2022-03-08 08:05 /user

We are using CDH version "Hadoop 3.0.0-cdh6.3.4"



Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.