itmap und custom).
SQL Fähigkeiten in v13:
* Select mit inner Join und left – right - full outer Join... Insert Kommando
INSERT INTO TABLE ora_audit_data
SELECT stack(1
,1,"TestDATA","999999","GPI"
... nto the table:
INSERT INTO TABLE ora_audit_data
SELECT id, message , audit_date, instance_name
FROM e... ql>
INSERT INTO TABLE emp PARTITION (deptno= 10)
SELECT empno,..... deptno from emp_load;
</code>
**Dy
<code>
.GenericJdbcImportExtractor: Using query: SELECT * FROM SYSTEM.AUD$ WHERE ''TESTER' <= USERID AND ... gpi_hive_tab.sql
</code>
Test:
<code sql>
hive>select count(*),userid from ext_ora_audit_gpi group by u... art-m-00009
</code>
Test mit:
<code sql>
SCOTT>select count(*),userid from "SCOTT"."EXT_ORA_AUDIT_GPI_H... ort.csv' overwrite into table hdfs_export;
hive> select count(*) from hdfs_export;
...
10000
</code>