Error: Field Pivoter allows only List, Map, List-Map, 'x' is an integer!

asked 2018-01-11 06:44:13 -0500

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I am fetching table data using JDBC Multitable where I have selected List-Map. Trying to use field pivoter for the fetched data and send the pivoted data through API using HTTP client destination. But when i specify the field to be pivoted suppose 'x' it gives the following error.

Error:Field pivoter allows only List,Map,List-Map,'x' is an integer.

As mentioned in the documentation, output format from JDBC Multitable is a List-Map: https://streamsets.com/documentation/...

What is the right format to configure field pivoter?

answered 2018-01-19 10:13:22 -0500

metadaddy

5464 ●26 ●41 ●81 https://about.me/patpa...

Field Pivoter is intended to take a set of data within a record and 'pivot' it into a series of records. For instance, you might be processing records that contain a /results field that is itself a list of maps:

image description

Pivoting on /results will produce a record for each element in the /results list:

image description

Although the output record from JDBC Multitable is a list-map, if the field x is an integer, you can't pivot on it.

edit flag offensive delete link

Comments

Thank you for the response @metadaddy

Maithri ( 2018-01-21 22:13:10 -0500 )edit

add a comment

Error: Field Pivoter allows only List, Map, List-Map, 'x' is an integer!

1 Answer

Comments

Question Tools

Stats

Related questions

Error: Field Pivoter allows only List, Map, List-Map, 'x' is an integer! edit

1 Answer

Comments

Question Tools

Stats

Related questions

Error: Field Pivoter allows only List, Map, List-Map, 'x' is an integer!