Re: Problem in WHERE clause querying HBase

2017-02-07 Thread Dechang Gu
_ From: G.A. Pagani Sent: Tuesday, February 7, 2017 3:34 AM To: user@drill.apache.org Subject: Re: Problem in WHERE clause querying HBase Hi all again, I have identified the issue and the behavior and the reason for the error: My HBase schema for that column I am trying to select is ac

Problem in WHERE clause querying HBase

2017-02-07 Thread G.A. Pagani
Hi all, I am a newbie in Drill and Hbase. I have installed Hbase 1.2.1 and Drill 1.9.0 both on a embedded (single host) configuration. I have enabled the HBase plugin with default parameters. I have a table that I manage to connect to and retrieve: SELECT CONVERT_FROM(row_key, 'UTF8') as key, CAS

Re: Problem in WHERE clause querying HBase

2017-02-07 Thread G.A. Pagani
Hi all again, I have identified the issue and the behavior and the reason for the error: My HBase schema for that column I am trying to select is actually: fogDecDB.Location.Latitute *with a capital "L"* however it gets somehow identified and properly parsed in the SELECT part of the statement

Problem in WHERE clause querying HBase

2017-02-07 Thread G.A. Pagani
Hi all, I am a newbie in Drill and Hbase. I have installed Hbase 1.2.1 and Drill 1.9.0 both on a embedded (single host) configuration. I have enabled the HBase plugin with default parameters. I have a table that I manage to connect to and retrieve: SELECT CONVERT_FROM(row_key, 'UTF8') as key, CAS