Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

JDBC Consumer - Mapping to Hive Metadata

I have 3 JDBC origins writing to the SDC RPC destination(same destination). Two of them are JDBC consumers and another one is JDBC multi-table consumer.

On the receiving side, i have an SDC RPC origin connected to the hive/hdfs and so on. My question is i'm using this ${record: attribute('jdbc.tables')} in the hive metadata at table name and its working fine for the data coming from Multitable consumer origin but its failing to feed the data coming from JDBC consumer. What should I add to the JDBC consumer so that hive can accept the data in this format ${record: attribute('jdbc.tables')} in the receiving side.

Here is the snapshot of the advanced table for the jdbc consumer. image description

JDBC Consumer - Mapping to Hive Metadata

I have 3 JDBC origins writing to the SDC RPC destination(same destination). Two of them are JDBC consumers and another one is JDBC multi-table consumer.

On the receiving side, i have an SDC RPC origin connected to the hive/hdfs and so on. My question is i'm using this ${record: attribute('jdbc.tables')} in the hive metadata at table name and its working fine for the data coming from Multitable consumer origin but its failing to feed the data coming from JDBC consumer. What should I add to the JDBC consumer so that hive can accept the data in this format ${record: attribute('jdbc.tables')} in the receiving side.

Here is the snapshot of the advanced table for the jdbc consumer. image description

ERROR SC : image description

JDBC Consumer - Mapping to Hive Metadata

I have 3 JDBC origins writing to the SDC RPC destination(same destination). Two of them are JDBC consumers and another one is JDBC multi-table consumer.

On the receiving side, i have an SDC RPC origin connected to the hive/hdfs and so on. My question is i'm using this ${record: attribute('jdbc.tables')} in the hive metadata at table name and its working fine for the data coming from Multitable consumer origin but its failing to feed the data coming from JDBC consumer. What should I add to the JDBC consumer so that hive can accept the data in this format ${record: attribute('jdbc.tables')} in the receiving side.

Here is the snapshot of the advanced table for the jdbc consumer. image description

ERROR SC : image description

click to hide/show revision 4
None

JDBC Query Consumer - Mapping to Hive Metadata

I have 3 JDBC origins writing to the SDC RPC destination(same destination). Two of them are JDBC consumers and another one is JDBC multi-table consumer.

On the receiving side, i have an SDC RPC origin connected to the hive/hdfs and so on. My question is i'm using this ${record: attribute('jdbc.tables')}${record:attribute('jdbc.tables')} in the hive metadata at table name and its working fine for the data coming from Multitable consumer origin but its failing to feed the data coming from JDBC consumer. What should I add to the JDBC consumer so that hive can accept the data in this format ${record: attribute('jdbc.tables')}${record:attribute('jdbc.tables')} in the receiving side.

Here is the snapshot of the advanced table for the jdbc consumer. image description

ERROR SC : image description