Support Questions
Find answers, ask questions, and share your expertise
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Inserting Data into External Hive table

Inserting Data into External Hive table

New Contributor

Hello, Am trying into insert the data into the new hive table from existing table using the following command.

INSERT INTO Database.employee_der

Select * from database.employee

Where employee_date=’2017-01-01’

Is there any SET commands that I can use to run without any memory issues.


Re: Inserting Data into External Hive table


@Rakesh Nethi I am assuming you are using hiveserver2 and beeline cli. Try adding export HADOOP_CLIENT_OPTS=-XX:MaxPermSize=256m to and restarting hiveserver2

Don't have an account?
Coming from Hortonworks? Activate your account here