> Hi Guys,
>
> I am new to aws, I am not sure how the hive works and store the data in
> aws.
>
> I have created a text table and orc table. where text table have data and
> when I do insert overwrite from text table the qury runs fine and when I do
> a count on orc table its zero.
>
> I have no clue where the data is going, any suggestions or ideas?
>
> Here is my query:
>
> hive> insert into table orc select * from text;
Query ID = hadoop_20180427190946_03edcce9-7a48-4876-aadb-6a7a1a862e50
Total jobs = 1
Launching Job 1 out of 1
Tez session was closed. Reopening...
Session re-established.
Status: Running (Executing on YARN cluster with App id
application_1524689752360_0058)
----------------------------------------------------------------------------------------------
* VERTICES MODE STATUS TOTAL COMPLETED RUNNING
PENDING FAILED KILLED *
----------------------------------------------------------------------------------------------
Map 1 .......... container SUCCEEDED 7 7 0 0
0 0
Reducer 2 ...... container SUCCEEDED 10 10 0 0
0 0
----------------------------------------------------------------------------------------------
*VERTICES: 02/02 [==========================>>] 100% ELAPSED TIME: 23.02
s *
----------------------------------------------------------------------------------------------
Loading data to table db.orc
OK
Time taken: 29.982 seconds
hive> select count(*) from orc;
Query ID = hadoop_20180427191026_faa4fa26-df05-4b52-aa31-f0c878b9c0bd
Total jobs = 1
Launching Job 1 out of 1
Status: Running (Executing on YARN cluster with App id
application_1524689752360_0058)
----------------------------------------------------------------------------------------------
* VERTICES MODE STATUS TOTAL COMPLETED RUNNING
PENDING FAILED KILLED *
----------------------------------------------------------------------------------------------
Map 1 container SUCCEEDED 0 0 0 0
0 0
Reducer 2 ...... container SUCCEEDED 1 1 0 0
0 0
----------------------------------------------------------------------------------------------
*VERTICES: 01/02 [==========================>>] 100% ELAPSED TIME: 3.49
s *
----------------------------------------------------------------------------------------------
OK
0
Time taken: 4.425 seconds, Fetched: 1 row(s)
hive> select count(*) from text;
Query ID = hadoop_20180427192401_fc0c4e26-0bb7-4d56-a7b9-17493cd5c88d
Total jobs = 1
Launching Job 1 out of 1
Tez session was closed. Reopening...
Session re-established.
Status: Running (Executing on YARN cluster with App id
application_1524689752360_0059)
----------------------------------------------------------------------------------------------
* VERTICES MODE STATUS TOTAL COMPLETED RUNNING
PENDING FAILED KILLED *
----------------------------------------------------------------------------------------------
Map 1 .......... container SUCCEEDED 7 7 0 0
0 0
Reducer 2 ...... container SUCCEEDED 1 1 0 0
0 0
----------------------------------------------------------------------------------------------
*VERTICES: 02/02 [==========================>>] 100% ELAPSED TIME: 10.19
s *
----------------------------------------------------------------------------------------------
OK
37504
Time taken: 15.506 seconds, Fetched: 1 row(s)
Thanks in advance.
