google / google/googlesql

BigQuery Dialect - CREATE TABLE CLONE and COPY

Open
#141 2 comments 0 reactions 0 assignees View on GitHub
Dominant language
C++
Stars
2.6k
Forks
260
PR merge metrics
No merged PRs in 30d

Description

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!

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.