drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "G.A. Pagani" <g.a.pag...@rug.nl>
Subject Problem in WHERE clause querying HBase
Date Tue, 07 Feb 2017 09:35:20 GMT
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,
CAST(fogDecDB.Location.latitude AS FLOAT) as lat  FROM fogDecDB LIMIT 10;
+-------------------------------------------------------------------+------------+
|                                key                                |
lat     |
+-------------------------------------------------------------------+------------+
| 00001e14dbf570471418f1c26384637a3154561bfc32062bbb416bedc165841d  |
51.971     |
| 0000c0ad64df90c8feebd4e191272413d01989c997d0e2aec34cf259f3207ddb  |
52.276943  |
| 00023c7cf936bd1933f8b0f690ae3f347d3fd3131278b4e0372d34dde9586b62  |
52.276943  |
| 0003164d842b488a1a0d8572ae06b983ceb3a645f41531acfe4962ad7ede80a2  |
52.276943  |
| 0003bd065e59d03f3907531279579025f49282a3aa1734d1c4d63df891420c58  |
52.1093    |
| 0006963d79ccf3a71f086f77b26a4db7da09a77c8b2c523fc51e04df4087abbd  |
52.1093    |
| 00069cd1f16dde18f4b6944c81015e4f7113ae447c02743a903814c0e64bb2e8  |
52.1093    |
| 00070d2b641fc506be01c4b0b15f102d01b43d34f0b98f054154d20ea1ad7aa1  |
52.1093    |
| 0007fd3e7db369f258173e7d47c13f81e3cbb48ecf446dd6ad4fe49bda2abcf0  |
52.276943  |
| 0009c8836878a0065a617ba066c5c6ba51a9e29d22c81a8df28be40352efd4bf  |
52.1093    |
+-------------------------------------------------------------------+------------+
10 rows selected (0.18 seconds)

The issue is when I add a WHERE statement to perform a kind of selection
e.g. only the rows with lat>52.0
I do the following command
SELECT CONVERT_FROM(row_key, 'UTF8') as key,
CAST(fogDecDB.Location.latitude AS FLOAT) as lat  FROM fogDecDB WHERE
fogDecDB.Location.latitude>52 LIMIT 10;
+------+------+
| key  | lat  |
+------+------+
+------+------+

Empty table, very weird...I have tried to CAST also in the WHERE statement
the fogDecDB.Location.latitude but same result.

Can anyone please shed some light on the issue. I of course googled a lot
with no luck.


Many thanks in advance.

Cheers,

Andrea

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message