Can we insert into external table

Question

I am debugging a Big Data code in Production environment of my company. Hive return the following error:

Exception: org.apache.hadoop.hive.ql.lockmgr.LockException: No record of lock  could be found, may have timed out
Killing DAG...
Execution has failed.
Exception in thread "main" java.sql.SQLException: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.tez.TezTask. 
    at org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:282)
    at org.apache.hive.jdbc.HiveStatement.executeUpdate(HiveStatement.java:392)
    at HiveExec.main(HiveExec.java:159)

After investigation, I have found that this error could be caused by BoneCP in connectionPoolingType property, but the cluster support team told me that they fixed this bug by upgrading BoneCP.

My question is: can we INSERT INTO an external table in Hive, because I have doubt about the insertion script ?

Is this a question about an Oracle External Table? – BobC Feb 22 '17 at 15:49 — BobC, Feb 22 '17 at 15:49
no, about Hive external tables – mttb12 Feb 22 '17 at 15:56 — mttb12, Feb 22 '17 at 15:56
Are you using Oracle as your metastore? – David דודו Markovitz Feb 22 '17 at 16:13 — David דודו Markovitz, Feb 22 '17 at 16:13

score 2 · Answer 1 · answered Feb 22 '17 at 15:44

2

Yes, you can insert into external table.

answered Feb 22 '17 at 15:44

David דודו Markovitz

42,900
6
64
88

Please try to use - `set datanucleus.connectionPoolingType=dbcp;` before running the insert – David דודו Markovitz Feb 22 '17 at 16:12

Can we insert into external table

1 Answers1