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 <aengelbre...@mapr.com>
> 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
