Cloudera Community
bryancjacobs
user rank
Frequent Visitor
My Accepted Solutions
Show All

Re: How to get the ConvertJSONToSQL to work with ...

by Frequent Visitor in Support Questions
‎10-30-2019 09:37 AM
‎10-30-2019 09:37 AM
I created a hack to solve this problem.   In the ConvertJSONtoSQL processor I put table name = personal information.  Notice the space.  This generated the sql like so: insert into personal information <snipped>   Then using a ReplaceTextProcessor I did a find and replace so such that the sql inserts were converted to the following: insert into `personal information` <snipped>   This works but is very hacky...would love to see the correct way to get the back ticks to work ... View more

How to get the ConvertJSONToSQL to work with a My...

by Frequent Visitor in Support Questions
‎10-24-2019 09:34 AM
‎10-24-2019 09:34 AM
I'm using the ConvertJSONToSQL processor, and the MySql table has a space in the name.  It appears to be the problem because when I remove the name from the table it works as expected.   I can successfully query the table from various tools and the mysql command line using back ticks "`" around the table name.   The table name: personal information   I've tried the following: `personal information` "personal information" 'personal information' \"personal information\" [personal information]   Any suggestions? ... View more
Labels:
Contact Me
Online
Offline
Last Visited
‎10-30-2019 03:21 PM
Community Statistics
Member Since ‎01-17-2018 05:36 PM
Last Visited ‎10-30-2019 03:21 PM
Posts 5