2

My source fields have special characters and need to be enclosed with backticks.

Ex: 

Source  -   ahj@#
Target  -  ` ahj@# `

How do I implement this in StreamSets - enclosing the column names?

metadaddy
  • 4,234
  • 1
  • 22
  • 46
Venkat
  • 31
  • 1

1 Answers1

0

I assume you're trying to write to MySQL. The correct way to do this is to enable Enclose Object Names in the JDBC tab and append ?sessionVariables=sql_mode=ANSI_QUOTES to the JDBC URL.

metadaddy
  • 4,234
  • 1
  • 22
  • 46
  • source - .csv file target - hive.. trying to use the field renamer in streamsets with below expression and getting error "FIELD_RENAMER_00 - Record 'Test2.csv::27' does not contain fields '/'([^a-z A-Z 0-9]*)'' Ex: Field names Streamset#,Test!,hive target should be ~Streamset#~,~Test!~,hive Source Field Expression : /'([^a-z A-Z 0-9]*)' Target Field Expression : /'$1' Please suggest how to resolve the issue. – Venkat Mar 19 '20 at 10:01