Big data SQL in action

Recently I have been engaged in implementing Oracle Big Data connector for customer we are helping.

Here is a preview of Big data SQL connector which can benefits from both Exadata smart scans and Hadoop massive palatalization…I will publish article in future and steps to implement BD SQL with Exadata and BDA appliance.

BDSQL> select /*+ MONITOR */ /* TESTAHK_YR */ count(*) FROM ORA_FLIGHTS group by YEAR;

COUNT(*)
———-
5411843
5967780
5683047
5270893
5327435
7129270
5180048
5271359
5076925
22
7140596
5070501
7141922
5527884
5384721
1311826
5351983
7453215
5041200
5202096
6488540
5092157
7009728
Elapsed: 00:00:15.34

Execution Plan
———————————————————-
Plan hash value: 3679660899

————————————————————————————————————————————–
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | TQ |IN-OUT| PQ Distrib |
————————————————————————————————————————————–
| 0 | SELECT STATEMENT | | 22 | 88 | 204K (2)| 00:00:08 | | | |
| 1 | PX COORDINATOR | | | | | | | | |
| 2 | PX SEND QC (RANDOM) | :TQ10001 | 22 | 88 | 204K (2)| 00:00:08 | Q1,01 | P->S | QC (RAND) |
| 3 | HASH GROUP BY | | 22 | 88 | 204K (2)| 00:00:08 | Q1,01 | PCWP | |
| 4 | PX RECEIVE | | 22 | 88 | 204K (2)| 00:00:08 | Q1,01 | PCWP | |
| 5 | PX SEND HASH | :TQ10000 | 22 | 88 | 204K (2)| 00:00:08 | Q1,00 | P->P | HASH |
| 6 | HASH GROUP BY | | 22 | 88 | 204K (2)| 00:00:08 | Q1,00 | PCWP | |
| 7 | PX BLOCK ITERATOR | | 123M| 471M| 202K (1)| 00:00:08 | Q1,00 | PCWC | |
| 8 | EXTERNAL TABLE ACCESS STORAGE FULL| ORA_FLIGHTS | 123M| 471M| 202K (1)| 00:00:08 | Q1,00 | PCWP | |
————————————————————————————————————————————–

Note
—–
– Degree of Parallelism is 2 because of table property
Statistics
———————————————————-
293 recursive calls
100 db block gets
302 consistent gets
8 physical reads
0 redo size
995 bytes sent via SQL*Net to client
563 bytes received via SQL*Net from client
3 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
23 rows processed

BDSQL>

BDS