[jira] [Created] (DRILL-7312) Allow case sensitivity for column names when it is supported by storage format

["Bohdan Kazydub (JIRA)" <ji...@apache.org>]

Bohdan Kazydub created DRILL-7312:
-------------------------------------

             Summary: Allow case sensitivity for column names when it is supported by storage format
                 Key: DRILL-7312
                 URL: https://issues.apache.org/jira/browse/DRILL-7312
             Project: Apache Drill
          Issue Type: Bug
            Reporter: Bohdan Kazydub


After upgrade to Calcite 1.20.0 (DRILL-7200), there is a following issue:
If HBase table has 2 columns which are equal if the case is ignored and are not equal if case is considered, e.g. a table has column 'F' and 'f', a following query
{code}
select * from hbase.`TestTableMultiCF` t
{code}
fails with following exception
{code}
 (org.apache.calcite.runtime.CalciteContextException) At line 1, column 8: Column 'F' is ambiguous
    sun.reflect.NativeConstructorAccessorImpl.newInstance0():-2
    sun.reflect.NativeConstructorAccessorImpl.newInstance():62
    sun.reflect.DelegatingConstructorAccessorImpl.newInstance():45
    java.lang.reflect.Constructor.newInstance():423
    org.apache.calcite.runtime.Resources$ExInstWithCause.ex():463
    org.apache.calcite.sql.SqlUtil.newContextException():824
    org.apache.calcite.sql.SqlUtil.newContextException():809
    org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError():4805
    org.apache.calcite.sql.validate.DelegatingScope.fullyQualify():496
    org.apache.calcite.sql.validate.SqlValidatorImpl.findTableColumnPair():3501
    org.apache.calcite.sql.validate.SqlValidatorImpl.isRolledUpColumn():3535
    org.apache.calcite.sql.validate.SqlValidatorImpl.expandStar():519
    org.apache.calcite.sql.validate.SqlValidatorImpl.expandSelectItem():429
    org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelectList():4069
    org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect():3376
    org.apache.calcite.sql.validate.SelectNamespace.validateImpl():60
    org.apache.calcite.sql.validate.AbstractNamespace.validate():84
    org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace():995
    org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery():955
    org.apache.calcite.sql.SqlSelect.validate():216
{code}

If HBase is case-sensitive in regards to column name Drill should support this as well when querying from HBase table.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)