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)