drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andries Engelbrecht <aengelbre...@mapr.com>
Subject Querying MapR-DB JSON Tables not returning results when specifying columns or CF's
Date Mon, 11 Sep 2017 17:21:32 GMT
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
Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message