[DRILL-1196] Does not support query of the form SELECT `schema`.`table`.* FROM `schema`.table`

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Fix Version/s: Future
• Component/s: SQL Parser

Environment

LINUX UBUNTU, WINDOWS 7

• Assignee: Unassigned
• Reporter: Alexander Zarei
• Created: 25/Jul/14 17:24
• Updated: 04/Jan/15 21:29
• Resolved: 04/Jan/15 21:26

Description

Query of the form Select `schema`.`table`.* from `schema`.table` returns an error from the parser. This affects loading data to TIBCO Spotfire BI tool.

sqlline query and returned error:

0: jdbc:drill:schema=hbase> SELECT `hive43.default`.`bella_table`.* FROM `hive43.default`.`bella_table`;
Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while running query.[error_id: "186471ae-6271-4b74-91d5-fbe80e6675d2"
endpoint {
address: "192.168.39.43"
user_port: 31010
control_port: 31011
data_port: 31012
}
error_type: 0
message: "Failure while parsing sql. < SqlParseException:[ Encountered ". *" at line 1, column 39.
Was expecting one of:
"FROM" ...
"," ...
"AS" ...
<IDENTIFIER> ...
<QUOTED_IDENTIFIER> ...
<BACK_QUOTED_IDENTIFIER> ...
<BRACKET_QUOTED_IDENTIFIER> ...
<UNICODE_QUOTED_IDENTIFIER> ...
"NOT" ...
"IN" ...
"BETWEEN" ...
"LIKE" ...
"SIMILAR" ...
"=" ...
">" ...
"<" ...
"<=" ...
">=" ...
"<>" ...
"+" ...
"-" ...
"*" ...
"/" ...
"||" ...
"AND" ...
"OR" ...
"IS" ...
"MEMBER" ...
"SUBMULTISET" ...
"MULTISET" ...
"[" ...
"." <IDENTIFIER> ...
"." <QUOTED_IDENTIFIER> ...
"." <BACK_QUOTED_IDENTIFIER> ...
"." <BRACKET_QUOTED_IDENTIFIER> ...
"." <UNICODE_QUOTED_IDENTIFIER> ...
"(" ...
]"
]
Error: exception while executing query (state=,code=0)

Issue Links

• duplicates: DRILL-1532 Query fails when specifying schema name with column name