Ask Your Question
1

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

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

this post is marked as community wiki

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?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

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

metadaddy gravatar image

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 more

Comments

Thank you for the response @metadaddy

Maithri gravatar imageMaithri ( 2018-01-21 22:13:10 -0600 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-01-11 06:44:13 -0600

Seen: 351 times

Last updated: Jan 19