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

Advertisements

Author: Abdul H Khan

Trying to be cloudy!

1 thought on “Big data SQL in action”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s