Create table hive dataproc with "time" keyword

[joarodrigues]

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

[joarodrigues]

Ok the solution was simply : 

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