0

This is the script I run on Hive:

CREATE EXTERNAL TABLE 'people'(
    'name' string,
    'surname' string,
    'age' string)
ROW FORMAT SERDE
    'org.apache.hadoop.hive.serde2.avro.AvroSerDe'
STORED AS INPUTFORMAT
    'org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat'
OUTPUTFORMAT
    'org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat'
LOCATION
    'gs://directory/subdirectory/'
TBLPROPERTIES (
    'avro.schema.url'='gs://directory/schema.avsc',
    'transient_lastDdlTime'='1644235388');

I get this error: Error while compiling statement:

FAILED: ParseException line 1:22 cannot recognize input near ''people'' '(' ''nam'' in table name

isherwood
  • 58,414
  • 16
  • 114
  • 157
Riccardo Lamera
  • 105
  • 1
  • 13

1 Answers1

1

could you pls enclose them with backtick( `)

CREATE EXTERNAL TABLE `people`(
    `name` string,
    `surname` string,
    `age` string)
...
Koushik Roy
  • 6,868
  • 2
  • 12
  • 33