Details
-
Bug
-
Status: Open
-
Major
-
Resolution: Unresolved
-
0.12.0
-
None
-
None
Description
When I create a hive table with table name start with underscore, I am able to create successfully. The command that I am using is as the following:
CREATE TABLE `_testtable` AS SELECT * FROM `dimdate`;
Once created, I issue a command (as following) to query all records from that table.
SELECT * FROM `_testtable`;
However, I got the error as the following:
Failed with exception java.io.IOException:org.apache.hadoop.mapred.InvalidInputException: Input path does not exist: hdfs://sandbox:8020/apps/hive/warehouse/_testtable
When I run the hdfs command to list the file in directory /apps/hive/warehouse/_testtable, I am able to get list of files in that directory.