Do you think this is a regression ? Can you try with Drill 1.11 ? Thanks, Padma
> On Sep 11, 2017, at 10:21 AM, Andries Engelbrecht <[email protected]> > wrote: > > 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
