[jira] [Created] (CALCITE-5151) when create hive jdbc schema,throw new IllegalArgumentException("cannot deduce null collation")

[cwb (Jira)]

cwb created CALCITE-5151:
----------------------------

             Summary: when create hive jdbc schema,throw new 
IllegalArgumentException("cannot deduce null collation")
                 Key: CALCITE-5151
                 URL: https://issues.apache.org/jira/browse/CALCITE-5151
             Project: Calcite
          Issue Type: Bug
          Components: core
    Affects Versions: 1.30.0
            Reporter: cwb


code:

Map<String,Object> props=new HashMap<String,Object>();
props.put("jdbcUrl", "jdbc:hive2://192.168.137.66:10000/db_test");
props.put("jdbcDriver", "org.apache.hive.jdbc.HiveDriver");
props.put("jdbcUser", "");
props.put("jdbcPassword", "");
props.put("jdbcSchema", "db_test");            
hiveSchema = JdbcSchema.create(rootSchema, "hiveSchema",props);

error :

java.lang.IllegalArgumentException: cannot deduce null collation

reason:

the method SqlDialects.getNullCollation(DatabaseMetaData databaseMetaData) 
throws new IllegalArgumentException("cannot deduce null collation");

and  the method  HiveDatabaseMetaData.nullsAreSortedAtEnd()  throws the 
follwing exeception

public boolean nullsAreSortedAtEnd() throws SQLException {
    throw new SQLFeatureNotSupportedException("Method not supported");
  }



--
This message was sent by Atlassian Jira
(v8.20.7#820007)