Diksha Chaturvedi created DRILL-8439:
----------------------------------------
Summary: Getting col__ prefix for columns that are not special
when extractHeader is enabled
Key: DRILL-8439
URL: https://issues.apache.org/jira/browse/DRILL-8439
Project: Apache Drill
Issue Type: Bug
Components: Metadata, SQL Parser
Affects Versions: 1.21.0
Environment: I've enabled extractHeader in the csv config of dfs
plugin.
Apache Drill version: apache-drill-1.21.0
No. of drillbits: Single
OS: Windows
Reporter: Diksha Chaturvedi
As per documentation, Drill appends col__ to the columns that start with a
number or special characters.
/**
* Prefix used to replace non-alphabetic characters at the start of
* a column name. For example, $foo becomes col_foo. Used
* because SQL does not allow _foo.
*/
public static final String COLUMN_PREFIX = "col_";
But in my case I'm getting it even for all alphabetical column name.
----
I have the following data in the CSV file,
||PRODUCTID||PRODUCTNAME||SUPPLIERID||CATEGORYID||UNIT||PRICE||
|1|Chais|1|1|10 boxes x 20 bags|18|
|2|Chang|1|1|24 - 12 oz bottles|19|
|3|Aniseed Syrup|1|2|12 - 550 ml bottles|10|
|4|Chef Anton's Cajun Seasoning|2|2|48 - 6 oz jars|22|
|5|Chef Anton's Gumbo Mix|2|2|36 boxes|21.35|
While querying on the csv file using following query:
{{SELECT * FROM dfs.`/var/lib/PRODUCT.csv`}}
The output is
[!https://i.stack.imgur.com/FBNmn.png|width=770,height=164!|https://i.stack.imgur.com/FBNmn.png]
I know about other criterias like
{{#UNITS}} is changed to {{col_UNITS}}
{{FINANCIAL$RECORD}} is changed to {{FINANCIAL_RECORD}}
{{}}
But what's with {{PRODUCTID}} ? In this case it has appended one extra
underscore also in the end.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
