Cloudera Community
malkoti_yogesh
user rank
New Contributor

Re: convertjsontosql generating sql with blank val...

by New Contributor in Support Questions
‎07-26-2019 08:16 AM
‎07-26-2019 08:16 AM
This is the error if I process the queue with the above content in PuthiiveQL PutHiveQL[id=89b230de-8dc5-18e0-9cac-668cfe8085b0] Failed to update Hive for StandardFlowFileRecord[uuid=1bb63fbe-29af-4422-b8a3-a282063514e8,claim=StandardContentClaim [resourceClaim=StandardResourceClaim[id=1564127716134-1, container=default, section=1], offset=186312, length=69],offset=0,name=9d11a5b0-78e8-43f1-9514-9e4c4509855c,size=69] due to Error while compiling statement: FAILED: ParseException line 1:58 cannot recognize input near '?' ',' '?' in value row constructor; routing to failure: org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: ParseException line 1:58 cannot recognize input near '?' ',' '?' in value row constructor ... View more

Re: convertjsontosql generating sql with blank val...

by New Contributor in Support Questions
‎07-26-2019 08:13 AM
‎07-26-2019 08:13 AM
This is the error if I process the queue with the above content in PuthiiveQL 16:11:15 SGT ERROR 89b230de-8dc5-18e0-9cac-668cfe8085b0 PutHiveQL[id=89b230de-8dc5-18e0-9cac-668cfe8085b0] Failed to update Hive for StandardFlowFileRecord[uuid=1bb63fbe-29af-4422-b8a3-a282063514e8,claim=StandardContentClaim [resourceClaim=StandardResourceClaim[id=1564127716134-1, container=default, section=1], offset=186312, length=69],offset=0,name=9d11a5b0-78e8-43f1-9514-9e4c4509855c,size=69] due to Error while compiling statement: FAILED: ParseException line 1:58 cannot recognize input near '?' ',' '?' in value row constructor; routing to failure: org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: ParseException line 1:58 cannot recognize input near '?' ',' '?' in value row constructor ... View more

convertjsontosql generating sql with blank values

by New Contributor in Support Questions
‎07-25-2019 03:44 PM
‎07-25-2019 03:44 PM
AVRO TO JSON produce content like below: { "id" : 92, "title" : "mr", "first" : "Alvin", "last" : "Lau" } convertjsontosql produce content like below: INSERT INTO nifi.copysql (id, title, first, last) VALUES (?, ?, ?, ?) Attached is the convertjsontosql processor setting. @Matt Burgess please assist ... View more
Labels:
Contact Me
Online
Offline
Last Visited
‎07-26-2019 08:33 AM
Community Statistics
Member Since ‎07-25-2019 08:31 AM
Last Visited ‎07-26-2019 08:33 AM
Posts 3