Hi,
Could you please advise if this is the correct way to fix the problem. Wanted
to use Power BI with Drill and got into the below issue.
https://github.com/apache/drill/commit/19886c11352cfa45bdb2da885a86e6500986e1e3
Thanks,
Sudip
-Original Message-
From: Sudip Mukherjee (JIRA) [mailto:j...@apache.org]
Sent: 21 January 2016 PM 04:16
To: dev@drill.apache.org
Subject: [jira] [Created] (DRILL-4294) InfoSchema is not returning column
metadata if the query contains escape character
Sudip Mukherjee created DRILL-4294:
--
Summary: InfoSchema is not returning column metadata if the query
contains escape character
Key: DRILL-4294
URL: https://issues.apache.org/jira/browse/DRILL-4294
Project: Apache Drill
Issue Type: Bug
Affects Versions: Future, 1.4.0
Reporter: Sudip Mukherjee
Below Query returns noting where escape character is "\\":
SELECT TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, CASE DATA_TYPE
WHEN 'ANY', 'MAP' THEN 'CHARACTER VARYING' ELSE DATA_TYPE END as DATA_TYPE,
CASE DATA_TYPE WHEN 'ANY', 'MAP' THEN 'CHARACTER VARYING' ELSE DATA_TYPE END as
DATA_TYPE_NAME, CASE DATA_TYPE WHEN 'BINARY' THEN
CHARACTER_MAXIMUM_LENGTH WHEN 'CHARACTER VARYING' THEN
CHARACTER_MAXIMUM_LENGTH WHEN 'CHARACTER' THEN
CHARACTER_MAXIMUM_LENGTH WHEN 'DATE' THEN DATETIME_PRECISION
WHEN 'INTERVAL' THEN INTERVAL_PRECISION WHEN 'VARCHAR' THEN
CHARACTER_MAXIMUM_LENGTH WHEN 'VARBINARY' THEN
CHARACTER_MAXIMUM_LENGTH ELSE NUMERIC_PRECISION END as
COLUMN_SIZE, NUMERIC_SCALE as DECIMAL_DIGITS, CASE DATA_TYPE
WHEN 'CHARACTER VARYING' THEN CHARACTER_MAXIMUM_LENGTH
WHEN 'CHARACTER' THEN CHARACTER_MAXIMUM_LENGTH WHEN 'VARCHAR' THEN
CHARACTER_MAXIMUM_LENGTH ELSE 9 END as BUFFER_LENGTH,
NUMERIC_PRECISION_RADIX, IS_NULLABLE as NULLABLE, 12 as
REMARKS, 13 as COLUMN_DEF, 14 as SQL_DATA_TYPE, 15 as
SQL_DATETIME_SUB, CHARACTER_MAXIMUM_LENGTH as CHAR_OCTET_LENGTH,
ORDINAL_POSITION, IS_NULLABLE, 18 as USER_DATA_TYPE FROM
INFORMATION_SCHEMA.COLUMNS WHERE TABLE_CATALOG LIKE 'DRILL' ESCAPE '\' AND
TABLE_SCHEMA LIKE 'dfs.tmp' ESCAPE '\' AND TABLE_NAME LIKE 'app\_client\_view'
ESCAPE '\' ORDER BY TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, ORDINAL_POSITION,
COLUMN_NAME
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
***Legal Disclaimer***
"This communication may contain confidential and privileged material for the
sole use of the intended recipient. Any unauthorized review, use or distribution
by others is strictly prohibited. If you have received the message by mistake,
please advise the sender by reply email and delete the message. Thank you."
**