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:[email protected]] Sent: 21 January 2016 PM 04:16 To: [email protected] 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." **********************************************************************
