I am trying to create a polybase external table in Azure Data warehouse for the Hive table which is stored as ORC(HD insight Data lake ) and partitioned by date when i query the external table its failing in SQL server without any proper error message. When i don't use partition i am able to access hive ORC table using external table , but with partition i am getting below error without any proper error message. Error: Msg 106000, Level 16, State 1, Line 33 Index: 23, Size: 23 Detail: Hive Table: CREATE EXTERNAL TABLE DL_ClickStream_fnl( . .)
PARTITIONED BY(TIME_STAMP Date)
STORED AS ORC; Azure DW External Table: CREATE EXTERNAL TABLE [stg].[dl_clickstream_procd]
( . . )
WITH (DATA_SOURCE = [AzureDataLakeStore_clusters],LOCATION = N'clusters/BLMSpark/hive/warehouse/coremetrics.db/dl_clickstream_procd'
,FILE_FORMAT = [ORCFileFormat_DL],REJECT_TYPE = VALUE,REJECT_VALUE = 2) File Format: CREATE EXTERNAL FILE FORMAT [ORCFileFormat_DL] WITH (FORMAT_TYPE = ORC)
... View more
