Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Please see the Cloudera blog for information on the Cloudera Response to CVE-2021-4428

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.

1 REPLY 1

Contributor

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