Created a MapR-DB JSON table, but not able to query data specifying column or
CF’s.
When doing a select * the data is returned.
i.e.
0: jdbc:drill:> select * from dfs.maprdb.`/sdc/nycbike` b limit 1;
+----------------------------+-------+-------+----------------+---------+-------------+-----------------+-----------------------+------------------------+-------------------+---------+-------------------+-------------------------+--------------------------+---------------------+-------------+----------------------+----------------------+---------------+----------------------------+-------------+---------------------------+
| _id | age | arc | avg_speed_mph | bikeid | birth
year | end station id | end station latitude | end station longitude | end
station name | gender | start station id | start station latitude | start
station longitude | start station name | start_date | starttime |
stoptime | tripduration | tripid | usertype
| station |
+----------------------------+-------+-------+----------------+---------+-------------+-----------------+-----------------------+------------------------+-------------------+---------+-------------------+-------------------------+--------------------------+---------------------+-------------+----------------------+----------------------+---------------+----------------------------+-------------+---------------------------+
| 2017-04-01 00:00:58-25454 | 51.0 | 0.39 | 7.2 | 25454 |
1966.0 | 430 | 40.7014851 | -73.98656928
| York St & Jay St | M | 217 | 40.70277159 |
-73.99383605 | Old Fulton St | 2017-04-01 | 2017-04-01
00:00:58 | 2017-04-01 00:04:14 | 195 | 2017-04-01 00:00:58-25454 |
Subscriber | {"end station id":"430"} |
+----------------------------+-------+-------+----------------+---------+-------------+-----------------+-----------------------+------------------------+-------------------+---------+-------------------+-------------------------+--------------------------+---------------------+-------------+----------------------+----------------------+---------------+----------------------------+-------------+---------------------------+
1 row selected (0.191 seconds)
However trying to specify a column or CF name nothing is returned.
Specify a column name
0: jdbc:drill:> select bikeid from dfs.maprdb.`/sdc/nycbike` b limit 10;
+--+
| |
+--+
+--+
No rows selected (0.067 seconds)
0: jdbc:drill:> select b.bikeid from dfs.maprdb.`/sdc/nycbike` b limit 1;
+--+
| |
+--+
+--+
No rows selected (0.062 seconds)
Specify a CF name the same result.
0: jdbc:drill:> select b.station from dfs.maprdb.`/sdc/nycbike` b limit 1;
+--+
| |
+--+
+--+
No rows selected (0.063 seconds)
Drill 1.10 and the user has full read/write/traverse permissions on the table.
Thanks
Andries
