The 'dual' table is a feature in Oracle only I believe.
There's an open Jira for this. You can try Edward Capriolo's project
(described in the jira) which allows you to use dual.
https://issues.apache.org/jira/browse/HIVE-1558
On Thu, Oct 18, 2012 at 2:29 AM, MiaoMiao liy...@gmail.com wrote:
Here's the fix: just fix the hive-log4j.properties in your hive install.
replace this line:
log4j.appender.EventCounter=org.apache.hadoop.metrics.jvm.EventCounter
with this:
log4j.appender.EventCounter=org.apache.hadoop.log.metrics.EventCounter
On Mon, Sep 17, 2012 at 10:34 AM, Robin
I have created HIVE-3465 for this issue.
On Mon, Sep 17, 2012 at 1:17 AM, MiaoMiao liy...@gmail.com wrote:
Yes, same problem here, sorry I missed your point and tested only once.
On Fri, Sep 14, 2012 at 10:13 PM, Kaufman Ng kauf...@cloudera.com wrote:
Did you run the insert into query twice
into table tmp.testtest select user,city from source;
On Fri, Sep 14, 2012 at 4:36 AM, Kaufman Ng kauf...@cloudera.com wrote:
Does anyone know if insert into statement is supposed to work across
databases/schemas?
For instance if I do this the target table gets appended correctly:
insert into table
Does anyone know if insert into statement is supposed to work across
databases/schemas?
For instance if I do this the target table gets appended correctly:
insert into table target select * from source;
However, if I have another target table in a different database, the
target table simply