You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "sunny rajpal (JIRA)" <ji...@apache.org> on 2017/11/22 10:10:00 UTC

[jira] [Updated] (DRILL-5985) Drill return IndexOutOfBoundsException when column name in the file doesnt match the exact case

     [ https://issues.apache.org/jira/browse/DRILL-5985?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

sunny rajpal updated DRILL-5985:
--------------------------------
    Remaining Estimate: 12h
     Original Estimate: 12h
           Description: 
columns in file has camel casing , when we write query with column name as full upper or lower it gives 

sample file
MyId    MyName  MyCity
1       john    texas
2       toshi   london

select * from dfs.`test.tsv`;
+-------+---------+---------+
| MyId  | MyName  | MyCity  |
+-------+---------+---------+
| 1     | john    | texas   |
| 2     | toshi   | london  |
+-------+---------+---------+

select myid from dfs.`test.tsv`;

Error: SYSTEM ERROR: IndexOutOfBoundsException

select MyId from dfs.`test.tsv`;

+-------+
| MyId  |
+-------+
| 1     |
| 2     |
+-------+


  was:
columns in file has camel casing , when we write query with column name as full upper or lower it gives 

Error: SYSTEM ERROR: IndexOutOfBoundsException: index: 32384, length: 4 (expected: range(0, 16384))

Fragment 0:0


> Drill return IndexOutOfBoundsException when column name in the file doesnt match the exact case
> -----------------------------------------------------------------------------------------------
>
>                 Key: DRILL-5985
>                 URL: https://issues.apache.org/jira/browse/DRILL-5985
>             Project: Apache Drill
>          Issue Type: Bug
>            Reporter: sunny rajpal
>   Original Estimate: 12h
>  Remaining Estimate: 12h
>
> columns in file has camel casing , when we write query with column name as full upper or lower it gives 
> sample file
> MyId    MyName  MyCity
> 1       john    texas
> 2       toshi   london
> select * from dfs.`test.tsv`;
> +-------+---------+---------+
> | MyId  | MyName  | MyCity  |
> +-------+---------+---------+
> | 1     | john    | texas   |
> | 2     | toshi   | london  |
> +-------+---------+---------+
> select myid from dfs.`test.tsv`;
> Error: SYSTEM ERROR: IndexOutOfBoundsException
> select MyId from dfs.`test.tsv`;
> +-------+
> | MyId  |
> +-------+
> | 1     |
> | 2     |
> +-------+



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)