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