1

I have used the following query to create an external table in SQL 2016 with polybase.

CREATE EXTERNAL TABLE dbo.SampleExternal (
    DateId INT NULL,
    CalendarQuarter TINYINT NULL,
    FiscalQuarter TINYINT NULL)
WITH (LOCATION='/SampleExternal.parquet',
    DATA_SOURCE=AzureStorage,
    FILE_FORMAT=ParquetFile);

Inserted the data to external table from local table and the parquet file was successfully generated in azure container.But while reading the parquet file ,coulmn names are shown as col-0,col-1.Is there any way to add original coumn names in parquet file as given in external tables. Column Names

Dev
  • 31
  • 3
  • same here if any one knows please reply. – Nair Athul Nov 17 '17 at 12:35
  • I was trying to interface the data from PDW to Hadoop into polybase. but column name is not working. I tried to contact ms and received a reply. This is a bug and should be fixed with a hotfix. – Suseong Park Jul 30 '19 at 03:15

1 Answers1

0

This seems 'as designed' in polybase. The consuming application has to do mapping from these numbered column names to meaningful column names. If the producing application is different than consumer app, they should handshake on the column mapping.

Joy George Kunjikkuru
  • 1,495
  • 13
  • 27