drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Padma Penumarthy <ppenumar...@mapr.com>
Subject Re: Querying MapR-DB JSON Tables not returning results when specifying columns or CF's
Date Mon, 11 Sep 2017 17:38:11 GMT
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 <aengelbrecht@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

Mime
View raw message