Create table hive dataproc with "time" keyword

Google Cloud Database
1

Hello

I had a script that worked with the time keyword since 2 weeks ago :

gcloud dataproc jobs submit hive \
  --cluster ${CLUSTER_NAME} \
  --region ${REGION} \
  --execute "
  CREATE EXTERNAL TABLE purchase (time BIGINT,   label STRING)
  PARTITIONED BY (   year INT,    month INT )
  STORED AS PARQUET
  LOCATION 'gs://${WAREHOUSE_BUCKET}'  ;

But since the same scripts returns me this error :

Error: Error while compiling statement: FAILED: ParseException line 1:32 cannot recognize input near 'time' 'BIGINT' ',' in column name or constraint (state=42000,code=40000)

I tried :

with :

time and \time and '‘time’’

Nothing worked.

Any idea on how to escape time ?

Thanks

2

Ok the solution was simply :

CREATE EXTERNAL TABLE purchase (\`time\` BIGINT,   label STRING)