1

Here is my create table

CREATE TABLE parquetpoc.employee USING PARQUET
LOCATION '/mnt/adlsQA/parquetPOC/output/employee'
PARTITIONED BY (`snapshot_year_month` string,`snapshot_day` string)

In the PARTITIONED BY I have tried, quotes, single quotes, double quotes, no quotes, and this thing `.

My folder structure is 

/mnt/adlsQA/parquetPOC/output/employee/snapshot_year_month=201807/snapshot_day=01

I am getting this error

Error in SQL statement: ParseException: 
extraneous input 'string' expecting ')'(line 3, pos 60)

How can I fix this?

test acc
  • 461
  • 1
  • 8
  • 19
  • change to **`snapshot_year_month` string,`snapshot_day` string** .. you have closing backtick after datatype for the first column. – Vamsi Prabhala Aug 16 '18 at 19:17
  • @VamsiPrabhala I tried that, same error. (Updated original post with the code I tried) – test acc Aug 16 '18 at 19:20
  • Can you specify what exactly you are trying to do? do you have some data on HDFS and you are trying to add them to the table? when does the error appear: while creating table or when querying data? Your table definition looks strange as you don't have any columns apart from partitions – serge_k Aug 17 '18 at 05:32

0 Answers0