Mailing-List: contact drill-user-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: drill-user@incubator.apache.org
Received-SPF: pass (athena.apache.org: domain of sphillips@maprtech.com
 designates 209.85.216.182 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAK=RhKRo7=UfxtueLxn4zhSHaVgqvtiOXZhF466Fo_zDV_G=PA@mail.gmail.com>
References: 
 <CAK=RhKRo7=UfxtueLxn4zhSHaVgqvtiOXZhF466Fo_zDV_G=PA@mail.gmail.com>
Date: Mon, 21 Apr 2014 10:32:38 -0700
Message-ID: 
 <CAA_-67f69Mpb7o3VOYCc7WzAyP3yPj11mU4fnJAH7eao9sgk1Q@mail.gmail.com>
Subject: Re: insert and query from hbase table
From: Steven Phillips <sphillips@maprtech.com>
To: "drill-dev@incubator.apache.org" <drill-dev@incubator.apache.org>
Cc: Apache Drill User <drill-user@incubator.apache.org>
Content-Type: multipart/alternative; boundary=089e0149cda0c6377004f790e285

--089e0149cda0c6377004f790e285
Content-Type: text/plain; charset=ISO-8859-1

You will need to put backticks around the column name, like so:

select `cf.a` from hbasetest.test;

The reason for this is currently that currently, without backticks, the
parser interprets cf as the table name.

insert statements are currently not supported.


On Mon, Apr 21, 2014 at 9:46 AM, Firas Khasawneh <kfiras@gmail.com> wrote:

> Hi all,
>
>
>
> I created a table in hbase and I tried to insert values and query from that
> table but I am not able to find how I can specify column family name in an
> insert or select statements. Below are more details:
>
>
>
> 0: jdbc:drill:schema=hbasetest> select * from hbasetest.test;
>
> +------------+------------+
>
> |  row_key   |    cf.a    |
>
> +------------+------------+
>
> | [B@c57cac7 | [B@57c1d525 |
>
> +------------+------------+
>
> 1 row selected (0.08 seconds)
>
>
>
>
>
> Select cf.a from hbasetest.test does not work I tried cf:a and nothing
> worked.
>
>
>
> insert into hbasetest.test values('row2','value2'); fails also/ I get the
> following message: "Failure while parsing sql. < ValidationException:[
> org.eigenbase.util.EigenbaseContextException: From line 1, column 23 to
> line 1, column 26 ] < EigenbaseContextException:[ From line 1, column 23 to
> line 1, column 26 ] < SqlValidatorException:[ Number of INSERT target
> columns (1) does not equal number of source items (2) ]"
>
>
>
> I tried many combinations but nothing worked. I am not able to find any
> docs also on sql syntax fro Drill.
>
>
>
> Thanks,
>
> Firas
>


-- 
 Steven Phillips
 Software Engineer

 mapr.com

--089e0149cda0c6377004f790e285--