Mailing-List: contact user-help@kudu.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@kudu.apache.org
MIME-Version: 1.0
In-Reply-To: <d5a00a5b-ceb7-b2ea-e858-cb5bf0a7b0a7@cloudera.com>
References: <CAMmwYg0PqN20wEOkvhVOoPry6+Sqm+b6AH9hRRHXtVSYw=OTiw@mail.gmail.com>
 <d5a00a5b-ceb7-b2ea-e858-cb5bf0a7b0a7@cloudera.com>
From: Nitin Agarwal <2nitinagarwal@gmail.com>
Date: Fri, 13 Oct 2017 13:23:50 -0600
Message-ID: <CAMmwYg2s0+vOrURxT3dMhL=i-Z1rG0tra4tjskCn9kg6imgM9Q@mail.gmail.com>
Subject: Re: Unable to access Kudu table created using Spark via Impala
To: user@kudu.apache.org
Content-Type: multipart/alternative; boundary="001a1144b42ec280a9055b7298a8"
archived-at: Fri, 13 Oct 2017 19:23:57 -0000

--001a1144b42ec280a9055b7298a8
Content-Type: text/plain; charset="UTF-8"

Thanks Alexey, that did the trick.

Nitin

On Fri, Oct 13, 2017 at 1:15 PM, Alexey Serbin <aserbin@cloudera.com> wrote:

> Hi Nitin,
>
> Impala needs to know about Kudu tables which were created 'externally'
> (i.e. not via Impala).  Have you run that 'CREATE EXTERNAL TABLE ...' via
> Impala shell already?  If not, you need to do so.  More information on the
> topic can be found at:
> http://kudu.apache.org/docs/kudu_impala_integration.html#_qu
> erying_an_existing_kudu_table_in_impala
>
>
> Best regards,
>
> Alexey
>
>
> On 10/13/17 12:10 PM, Nitin Agarwal wrote:
>
>> Hi, I used Spark and KuduContext to create a table in Kudu. I can see the
>> table in Kudu UI and can access it through Spark. However I am unable to
>> access that table via Impala. I have issued invalidate metadata in Impala
>> but I am still unable to list the table.
>>
>> So what do I need to do to access this table via Impala?
>>
>> I am using Kudu version kudu 1.4.0-cdh5.12.1 with Spark 1.6.x
>>
>> This is what I see in Kudu UI for my table
>>
>> |CREATE EXTERNAL TABLE `nums.telephone_number` STORED AS KUDU
>> TBLPROPERTIES( 'kudu.table_name' = 'nums.telephone_number',
>> 'kudu.master_addresses' = 'ff58-29.idc1.level3.com:7051 <
>> http://ff58-29.idc1.level3.com:7051>,ff58-30.idc1.level3.com:7051 <
>> http://ff58-30.idc1.level3.com:7051>,ff58-34.idc1.level3.com:7051');|
>> |Nitin|
>>
>
>

--001a1144b42ec280a9055b7298a8
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Thanks Alexey, that did the trick.=C2=A0<div><br></div><di=
v>Nitin</div></div><div class=3D"gmail_extra"><br><div class=3D"gmail_quote=
">On Fri, Oct 13, 2017 at 1:15 PM, Alexey Serbin <span dir=3D"ltr">&lt;<a h=
ref=3D"mailto:aserbin@cloudera.com" target=3D"_blank">aserbin@cloudera.com<=
/a>&gt;</span> wrote:<br><blockquote class=3D"gmail_quote" style=3D"margin:=
0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi Nitin,<br>
<br>
Impala needs to know about Kudu tables which were created &#39;externally&#=
39; (i.e. not via Impala).=C2=A0 Have you run that &#39;CREATE EXTERNAL TAB=
LE ...&#39; via Impala shell already?=C2=A0 If not, you need to do so.=C2=
=A0 More information on the topic can be found at:<br>
<a href=3D"http://kudu.apache.org/docs/kudu_impala_integration.html#_queryi=
ng_an_existing_kudu_table_in_impala" rel=3D"noreferrer" target=3D"_blank">h=
ttp://kudu.apache.org/docs/ku<wbr>du_impala_integration.html#_qu<wbr>erying=
_an_existing_kudu_table_<wbr>in_impala</a><br>
<br>
<br>
Best regards,<br>
<br>
Alexey<span class=3D""><br>
<br>
<br>
On 10/13/17 12:10 PM, Nitin Agarwal wrote:<br>
</span><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-=
left:1px #ccc solid;padding-left:1ex"><span class=3D"">
Hi, I used Spark and KuduContext to create a table in Kudu. I can see the t=
able in Kudu UI and can access it through Spark. However I am unable to acc=
ess that table via Impala. I have issued invalidate metadata in Impala but =
I am still unable to list the table.<br>
<br>
So what do I need to do to access this table via Impala?<br>
<br>
I am using Kudu version kudu 1.4.0-cdh5.12.1 with Spark 1.6.x<br>
<br>
This is what I see in Kudu UI for my table<br>
<br></span>
|CREATE EXTERNAL TABLE `nums.telephone_number` STORED AS KUDU TBLPROPERTIES=
( &#39;kudu.table_name&#39; =3D &#39;nums.telephone_number&#39;, &#39;kudu.=
master_addresses&#39; =3D &#39;<a href=3D"http://ff58-29.idc1.level3.com:70=
51" rel=3D"noreferrer" target=3D"_blank">ff58-29.idc1.level3.com:7051</a> &=
lt;<a href=3D"http://ff58-29.idc1.level3.com:7051" rel=3D"noreferrer" targe=
t=3D"_blank">http://ff58-29.idc1.level3.co<wbr>m:7051</a>&gt;,<a href=3D"ht=
tp://ff58-30.idc1.level3.com:7051" rel=3D"noreferrer" target=3D"_blank">ff5=
8-30.idc1.level3.co<wbr>m:7051</a> &lt;<a href=3D"http://ff58-30.idc1.level=
3.com:7051" rel=3D"noreferrer" target=3D"_blank">http://ff58-30.idc1.level3=
.co<wbr>m:7051</a>&gt;,<a href=3D"http://ff58-34.idc1.level3.co">ff58-34.id=
c1.level3.co</a><wbr>m:7051&#39;);|<br>
|Nitin|<br>
</blockquote>
<br>
</blockquote></div><br></div>

--001a1144b42ec280a9055b7298a8--