DRILL-3993: Fix unit test failures connected with support Calcite 1.13 - Use root schema as default for describe table statement. Fix TestOp…
DRILL-3993: Fix unit test failures connected with support Calcite 1.13- Use root schema as default for describe table statement.Fix TestOpenTSDBPlugin.testDescribe() and TestInfoSchemaOnHiveStorage.varCharMaxLengthAndDecimalPrecisionInInfoSchema() unit tests.- Modify expected results for tests:TestPreparedStatementProvider.invalidQueryValidationError();TestProjectPushDown.testTPCH1();TestProjectPushDown.testTPCH3();TestStorageBasedHiveAuthorization.selectUser1_db_u0_only();TestStorageBasedHiveAuthorization.selectUser0_db_u1g1_only()- Fix TestCTAS.whenTableQueryColumnHasStarAndTableFiledListIsSpecified(), TestViewSupport.createViewWhenViewQueryColumnHasStarAndViewFiledListIsSpecified(), TestInbuiltHiveUDFs.testIf(), testDisableUtf8SupportInQueryString unit tests.- Fix UnsupportedOperationException and NPE for jdbc tests.- Fix AssertionError: Conversion to relational algebra failed to preserve datatypes*DrillCompoundIdentifier:According to the changes, made in [CALCITE-546], star Identifier is replaced by empty string during parsing the query. Since Drill uses its own DrillCompoundIdentifier, it should also replace star by empty string before creating SqlIdentifier instance to avoid further errors connected with star column. see SqlIdentifier.isStar() method.*SqlConverter:In [CALCITE-1417] added simplification of expressions which should be projected every time when a new project rel node is created using RelBuilder. It causes assertion errors connected with types nullability. This hook was set to false to avoid project expressions simplification. See usage of this hook and RelBuilder.project() method.In Drill the type nullability of the function depends on only the nullability of its arguments. In some cases, a function may return null value even if it had non-nullable arguments. When Calice simplifies expressions, it checks that the type of the result is the same as the type of the expression. Otherwise, makeCast() method is called. But when a function returns null literal, this cast does nothing, even when the function has a non-nullable type. So to avoid this issue, method makeCast() was overridden.*DrillAvgVarianceConvertlet:Problem with sum0 and specific changes in old Calcite (it is CALCITE-777). (see HistogramShuttle.visitCall method) Changes were made to avoid changes in Calcite.*SqlConverter, DescribeTableHandler, ShowTablesHandler:New Calcite tries to combine both default and specified workspaces during the query validation. In some cases, for example, when describe table statement is used, Calcite tries to find INFORMATION_SCHEMA in the schema used as default. When it does not find the schema, it tries to find a table with such name. For some storage plugins, such as opentsdb and hbase, when a table was not found, the error is thrown, and the query fails. To avoid this issue, default schema was changed to root schema for validation stage for describe table and show tables queries.