George Chow created DRILL-884:
---------------------------------
Summary: Query used to derive result set metadata for Tableau's
"Custom SQL" does not run
Key: DRILL-884
URL: https://issues.apache.org/jira/browse/DRILL-884
Project: Apache Drill
Issue Type: Bug
Reporter: George Chow
The following style of query is used by Tableau to derive the metadata of a
custom SQL:
>From Tableau's protocol server log:
{code}
2014-05-30 18:35:39.718 (-,-,-,-) 0ea0: ODBCProtocol::ReadMetadataImpl:
Attempting to read metadata from the prepared / executed query result set.
2014-05-30 18:35:39.718 (-,-,-,-) 0ea0: ODBCProtocolImpl::ReadMetadataImpl:
Reading metadata using a prepared statement.
2014-05-30 18:35:39.718 (-,-,-,-) 0ea0: <QUERY protocol='0367b1f0'>
2014-05-30 18:35:39.718 (-,-,-,-) 0ea0: SELECT *
2014-05-30 18:35:39.718 (-,-,-,-) 0ea0: FROM (
2014-05-30 18:35:39.718 (-,-,-,-) 0ea0: select * from
dfs.`default`.`/opt/drill/raw-files/click1.json`
2014-05-30 18:35:39.718 (-,-,-,-) 0ea0: ) `TableauSQL`
2014-05-30 18:35:39.718 (-,-,-,-) 0ea0: WHERE (0 = 1)
2014-05-30 18:35:39.718 (-,-,-,-) 0ea0: </QUERY>
2014-05-30 18:35:39.718 (-,-,-,-) 0ea0: ODBCProtocolImpl::ReadMetadataImpl:
SQLPrepare failed. Reading metadata using an executed query.
2014-05-30 18:35:47.640 (-,-,-,-) 0ea0: ODBCProtocolImpl::ReadMetadataImpl: No
columns were reported!
{code}
Extracting the query to run inside sqlline shows the problem:
{code}
0: jdbc:drill:zk=localhost:5181> select * from (select * from
dfs.`default`.`/opt/drill/raw-files/click1.json`) `TableauSQL` where (0=1);
+--+
| |
+--+
+--+
No rows selected (9.059 seconds)
{code}
--
This message was sent by Atlassian JIRA
(v6.2#6252)
