[
https://issues.apache.org/jira/browse/DRILL-1196?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14074796#comment-14074796
]
Alexander Zarei commented on DRILL-1196:
----------------------------------------
Is drill supposed to support query of the form:
SELECT [hive43.default].[sneaky].* FROM [hive43.default].[sneaky]
?
If it could support this types of query it would be possible to load data into
Microsoft Power Pivot Directly from Drill instead of having to import the data
to an Excel sheet and then transferring it to PowerPivot/PowerView/Data Model.
Sqlline query and error follow:
0: jdbc:drill:schema=hbase> SELECT [hive43.default].[sneaky].* FROM
[hive43.default].[sneaky];
Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while
running query.[error_id: "e98b76f1-33a6-4129-86c6-290962bf720d"
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 8.
Was expecting one of:
"UNION" ...
"INTERSECT" ...
"EXCEPT" ...
"ORDER" ...
"LIMIT" ...
"OFFSET" ...
"FETCH" ...
"DISTINCT" ...
"ALL" ...
<IDENTIFIER> ...
<QUOTED_IDENTIFIER> ...
<BACK_QUOTED_IDENTIFIER> ...
<BRACKET_QUOTED_IDENTIFIER> ...
<UNICODE_QUOTED_IDENTIFIER> ...
"*" ...
"+" ...
"-" ...
<UNSIGNED_INTEGER_LITERAL> ...
<DECIMAL_NUMERIC_LITERAL> ...
<APPROX_NUMERIC_LITERAL> ...
<BINARY_STRING_LITERAL> ...
<PREFIXED_STRING_LITERAL> ...
<QUOTED_STRING> ...
<UNICODE_STRING_LITERAL> ...
"TRUE" ...
"FALSE" ...
"UNKNOWN" ...
"NULL" ...
<LBRACE_D> ...
<LBRACE_T> ...
<LBRACE_TS> ...
"DATE" ...
"TIME" ...
"TIMESTAMP" ...
"INTERVAL" ...
"?" ...
"CAST" ...
"EXTRACT" ...
"POSITION" ...
"CONVERT" ...
"TRANSLATE" ...
"OVERLAY" ...
"FLOOR" ...
"CEIL" ...
"CEILING" ...
"SUBSTRING" ...
"TRIM" ...
<LBRACE_FN> ...
"MULTISET" ...
"ARRAY" ...
"SPECIFIC" ...
"ABS" ...
"AVG" ...
"CARDINALITY" ...
"CHAR_LENGTH" ...
"CHARACTER_LENGTH" ...
"COALESCE" ...
"COLLECT" ...
"CUME_DIST" ...
"COUNT" ...
"CURRENT_DATE" ...
"CURRENT_TIME" ...
"CURRENT_TIMESTAMP" ...
"DENSE_RANK" ...
"ELEMENT" ...
"EXP" ...
"FIRST_VALUE" ...
"FUSION" ...
"LAST_VALUE" ...
"LN" ...
"LOCALTIME" ...
"LOCALTIMESTAMP" ...
"LOWER" ...
"MAX" ...
"MIN" ...
"MOD" ...
"NULLIF" ...
"OCTET_LENGTH" ...
"PERCENT_RANK" ...
"POWER" ...
"RANK" ...
"ROW_NUMBER" ...
"SQRT" ...
"STDDEV_POP" ...
"STDDEV_SAMP" ...
"SUM" ...
"UPPER" ...
"VAR_POP" ...
"VAR_SAMP" ...
"CURRENT_CATALOG" ...
"CURRENT_DEFAULT_TRANSFORM_GROUP" ...
"CURRENT_PATH" ...
"CURRENT_ROLE" ...
"CURRENT_SCHEMA" ...
"CURRENT_USER" ...
"SESSION_USER" ...
"SYSTEM_USER" ...
"USER" ...
"NEW" ...
"CASE" ...
"CURSOR" ...
"ROW" ...
"NOT" ...
"EXISTS" ...
"(" ...
]"
]
> Does not support query of the form SELECT `schema`.`table`.* FROM
> `schema`.table`
> ---------------------------------------------------------------------------------
>
> Key: DRILL-1196
> URL: https://issues.apache.org/jira/browse/DRILL-1196
> Project: Apache Drill
> Issue Type: Bug
> Components: SQL Parser
> Environment: LINUX UBUNTU, WINDOWS 7
> Reporter: Alexander Zarei
>
> 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)
--
This message was sent by Atlassian JIRA
(v6.2#6252)
