Re: the projected columns are getting converted to a star for create statement

2021-07-27 Thread Yanjing Wang
Maybe we need to add a config interface and default instance like SqlToRelConverter to signify this conversion. Saurabh Gupta 于2021年7月27日周二 下午11:15写道: > Hi Team, > There is one scenario for ex: create table temp1 as select c1,c2 from > table1 > .And table1 has only c1 , c2 columns so this query

the projected columns are getting converted to a star for create statement

2021-07-27 Thread Saurabh Gupta
Hi Team, There is one scenario for ex: create table temp1 as select c1,c2 from table1 .And table1 has only c1 , c2 columns so this query is getting translated as : create table temp1 as select * from table1. In this scenario we don't want the column to be converted to a star . One of the

[jira] [Created] (CALCITE-4705) calcite should support hint like /*+ skewjoin(a(c0, c1)) */

2021-07-27 Thread jibiyr (Jira)
jibiyr created CALCITE-4705: --- Summary: calcite should support hint like /*+ skewjoin(a(c0, c1)) */ Key: CALCITE-4705 URL: https://issues.apache.org/jira/browse/CALCITE-4705 Project: Calcite Issue

[jira] [Created] (CALCITE-4704) Log produced plan after rule application using explain formatting

2021-07-27 Thread Stamatis Zampetakis (Jira)
Stamatis Zampetakis created CALCITE-4704: Summary: Log produced plan after rule application using explain formatting Key: CALCITE-4704 URL: https://issues.apache.org/jira/browse/CALCITE-4704

ClassCastException: FamilyOperandTypeChecker cannot be cast to SqlOperandMetadata

2021-07-27 Thread wrstrs
Hi, all how to solve this problem? my code: String sql = "select UNIX_TIMESTAMP(concat(substr('2021-07-27 12:12:12',0,11),'09:00:00'))"; SqlOperatorTable opTab = SqlLibraryOperatorTableFactory.INSTANCE.getOperatorTable(EnumSet.of( SqlLibrary.HIVE, SqlLibrary.SPARK,