bigquery-emulator icon indicating copy to clipboard operation
bigquery-emulator copied to clipboard

Not able to create a clustered table using create table query

Open Bitsy-Chuck opened this issue 1 year ago • 2 comments

What happened?

when using the following create query i am getting the following error create table if not exists `test-project.test-dataset.test-table`( col1 STRING,col2 STRING,col3 INT64) cluster by col1;

I want to create a table with clustering key

What did you expect to happen?

Table should be created by clustering key

How can we reproduce it (as minimally and precisely as possible)?

➜ ~ bq '--api=http://0.0.0.0:55487' -project_id=test-project query "create table if not exists test-dataset.linked_user_store_scylla( linked_ucid STRING,ucid STRING,ts INT64) cluster by ucid;"

Anything else we need to know?

No response

Bitsy-Chuck avatar Dec 11 '24 11:12 Bitsy-Chuck

Hello, any update here please?

Ojasv-Singh-Zeotap avatar Feb 27 '25 08:02 Ojasv-Singh-Zeotap

Hi, interested by a fix as well, CLUSTER BY seem to be an issue

ElieGallet avatar Nov 06 '25 08:11 ElieGallet