Member since
10-26-2018
1
Post
0
Kudos Received
0
Solutions
10-26-2018
03:02 PM
I came across this issue, somehow Polybase table didn't allow the partition by column as part of the definition. Removing the column from selection list resolved the issue. In your case, your Polybase table structure might have 24 columns including partition by column. Example: polybase table: CREATE EXTERNAL TABLE [dbo].[ProcessControl] ( [tablename] varchar(50) COLLATE Latin1_General_100_CI_AS_KS_WS NULL, [lastupdatetimestamp] datetime2(3) NULL, [etlcreateddatetime] datetime2(3) NULL ) -- etlcreatedate date NULL -- partition by column is not accepted in column list. WITH (LOCATION='/data/target/process_control', . . ) Hive table: CREATE EXTERNAL TABLE `process_control`( `tablename` string, `pdwlastupdatetimestamp` timestamp, `etlcreateddatetime` timestamp) PARTITIONED BY (
`etlcreatedate` string) ROW FORMAT DELIMITED ... STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.orc.OrcInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat' Thanks, Santosh
... View more