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)
