| \ | Hive | RDBMS | |
|---|---|---|---|
| QL | HQL | SQL | |
| storage | HDFS | raw device / local FS | |
| exec | MapReduce | Executor | |
| exec delay | hi | lo | |
| exec data size | L | S | |
| data format | customize | predefined | |
| data update | No, read-only | yes | |
| index | no, mapreduce(slow) | yes |
| \ | Hive | RDBMS | |
|---|---|---|---|
| QL | HQL | SQL | |
| storage | HDFS | raw device / local FS | |
| exec | MapReduce | Executor | |
| exec delay | hi | lo | |
| exec data size | L | S | |
| data format | customize | predefined | |
| data update | No, read-only | yes | |
| index | no, mapreduce(slow) | yes |