Database Reference
In-Depth Information
| Nissan |
| Dodge |
| BMW |
| Toyota |
| Fisker |
| Honda |
| Chevrolet |
| Jeep |
+-----------+
Returned 10 row(s) in 0.68s
And for the
motorcycles
table, we will use the
distinct
command as follows:
[Hadoop.testdomain:21000] > select
distinct(make) from motorcycles;
Query finished, fetching results ...
+---------+
| make |
+---------+
| Can-am |
| Suzuki |
| BMW |
| Zero |
| KTM |
| Bramo |
| Honda |
| Triumph |
| Ducati |
| Harley |
+---------+
Returned 10 row(s) in 0.48s
