# Revision history [back]

### 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.

### 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.

ERROR SC :

### 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.

ERROR SC :

 4 None jeff 3097 ●17 ●41 ●70

### 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.

ERROR SC :