· 8 years ago · May 10, 2018, 02:54 AM
1CREATE TABLE my_table
2(
3 entry_name varchar(10),
4 sd_timestamp timestamp(6)
5);
6
7insert into my_table values('e-1',CURRENT_TIMESTAMP);
8insert into my_table values('e-2',CURRENT_TIMESTAMP);
9insert into my_table values('e-3',CURRENT_TIMESTAMP);
10
11SELECT * FROM my_table;
12ENTRY_NAME SD_TIMESTAMP
13e-1 09-MAY-18 06.45.24.963327000 PM
14e-2 09-MAY-18 06.45.39.291241000 PM
15e-3 09-MAY-18 06.45.44.748736000 PM
16
17$ hadoop fs -ls /oracle-ingest
18/oracle-ingest/50201861895275.orc
19
20hive> CREATE EXTERNAL TABLE IF NOT EXISTS my_oracle_table
21(
22 ENTRY_NAME STRING,
23 SD_TIMESTAMP STRING
24)
25STORED AS ORC
26LOCATION '/oracle-ingest';
27
28hive> select * from my_oracle_table;
29e-1 2018-05-09 18:45:24.963327
30e-2 2018-05-09 18:45:39.291241
31e-3 2018-05-09 18:45:44.748736