1

I am loading a BCPed data which has few rows that contains newline character in data itself. So when I try to import those data it's throwing an error. To Solve this issue I need to specify row terminator in external file format as \r\n. Does polybase allow row terminator? if so how?

HimalayanNinja
  • 421
  • 3
  • 11

1 Answers1

1

Does polybase allow row terminator?

Row terminator feature of Polybase is not supported currently. There is a feature request which related to your question on Azure feedback page. The state of this feature is still under review. Link below is for your reference.

Polybase: allow field/row terminators within string fields

GregGalloway
  • 11,355
  • 3
  • 16
  • 47
Amor
  • 8,325
  • 2
  • 19
  • 21
  • This is very important feature as we are stuck and may have to go alternative approach. Do you know when can we expect this feature? – HimalayanNinja Apr 14 '17 at 18:35
  • Since the state of this feature is still under review. We can't get the exact time. – Amor Apr 17 '17 at 02:35