BigQuery Dialect - CREATE TABLE CLONE and COPY

[jrbangit]

Hi, All

just wondering if there is a support coming for these bigquery statements?

CREATE TABLE `tbl`
CLONE `src_tbl`;

CREATE TABLE `tbl`
COPY `src_tbl`

reference: https://cloud.google.com/bigquery/docs/reference/standard-sql/data-definition-language#create_table_copy

currently, I'm encountering this limitation below.

com.google.zetasql.SqlException: CREATE TABLE CLONE is not supported [at 4:7]

edit: it seems COPY is supported, only CLONE is not supported.

Thank you!

[matthewcbrown]

Support in the evaluator is not likely, but it is supported in the various other api calls (Analyzer.java).

You may need to modify the LanguageOptions to enable the statements you need enabled:
You can see an example here:

zetasql/javatests/com/google/zetasql/AnalyzerTest.java

Line 284 in 206e78c

public void analyzeStatement_supportsStatementKinds() {

AnalyzerOptions analyzerOptions = new AnalyzerOptions();
analyzerOptions
    .getLanguageOptions()
    .setSupportedStatementKinds(ImmutableSet.of(ResolvedNodeKind.RESOLVED_CREATE_TABLE_STMT));
Analyzer.analyzeStatement(sql, analyzerOptions, new SimpleCatalog(""))

[pratnaparkhi2000]

Hi,
CLONE query works for me.

CREATE TABLE <project_id>.<dataset_name>.<cloned_table_name>
CLONE <project_id>.<dataset_name>.<original_table_name> FOR SYSTEM_TIME AS OF CURRENT_TIMESTAMP();