Insert data from Hive into Solr

You can insert data to Solr through an external Hive table, using the INSERT Hive statement.

To insert data, use the name of the Solr table as the target for the Hive INSERT statement:

INSERT INTO [***TARGET TABLE***]
      SELECT id, field1_s, field2_i FROM [***SOURCE TABLE***];

For example, to insert

INSERT INTO solr SELECT claim_id_s, line_id_s, member_id_s, service_dt_i FROM sometable