Integrating Apache Hive with Kafka, Spark, and BI
Also available as:

Set consumer and producer properties as table properties

You can use Kafka consumer and producer properties in the TBLPROPERTIES clause of a Hive query. By prefixing the key with kafka.consumer or kafka.producer, you can set the table properties.

For example, if you want to inject 5000 poll records into the Kafka consumer, use the following syntax.
ALTER TABLE kafka_table SET TBLPROPERTIES ("kafka.consumer.max.poll.records"="5000");