You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Rajendra Bhat <ra...@gmail.com> on 2016/10/25 07:09:45 UTC
Connect metadata
Hi Team,
I have configured only meta store and started the meta store service, hwich
i ma used on presto.
I need create table on metastore.. how can i able create that.. as i am not
started hive server service, bcoz hadoop not installed on my syatem.
--
Thanks and
Regards
Rajendra Bhat
Re: Connect metadata
Posted by Rajendra Bhat <ra...@gmail.com>.
I have setup the meta store. I need to create hive external table, table
data stored in S3 with parquet format.
As i am not installed hive server for execute create command. How can I
possible execute to create table commands..?
On Tue, Oct 25, 2016 at 1:41 PM, Rajendra Bhat <ra...@gmail.com> wrote:
> I need external table. data should refer from S3.
>
> On Tue, Oct 25, 2016 at 1:00 PM, Damien Carol <da...@gmail.com>
> wrote:
>
>> You could use CTAS in presto
>>
>> 2016-10-25 9:09 GMT+02:00 Rajendra Bhat <ra...@gmail.com>:
>>
>>> Hi Team,
>>>
>>> I have configured only meta store and started the meta store service,
>>> hwich i ma used on presto.
>>>
>>> I need create table on metastore.. how can i able create that.. as i am
>>> not started hive server service, bcoz hadoop not installed on my syatem.
>>>
>>> --
>>> Thanks and
>>> Regards
>>>
>>> Rajendra Bhat
>>>
>>
>>
>
>
> --
> Thanks and
> Regards
>
> Rajendra Bhat
>
--
Thanks and
Regards
Rajendra Bhat
Re: Connect metadata
Posted by Rajendra Bhat <ra...@gmail.com>.
I need external table. data should refer from S3.
On Tue, Oct 25, 2016 at 1:00 PM, Damien Carol <da...@gmail.com>
wrote:
> You could use CTAS in presto
>
> 2016-10-25 9:09 GMT+02:00 Rajendra Bhat <ra...@gmail.com>:
>
>> Hi Team,
>>
>> I have configured only meta store and started the meta store service,
>> hwich i ma used on presto.
>>
>> I need create table on metastore.. how can i able create that.. as i am
>> not started hive server service, bcoz hadoop not installed on my syatem.
>>
>> --
>> Thanks and
>> Regards
>>
>> Rajendra Bhat
>>
>
>
--
Thanks and
Regards
Rajendra Bhat
Re: Connect metadata
Posted by Damien Carol <da...@gmail.com>.
You could use CTAS in presto
2016-10-25 9:09 GMT+02:00 Rajendra Bhat <ra...@gmail.com>:
> Hi Team,
>
> I have configured only meta store and started the meta store service,
> hwich i ma used on presto.
>
> I need create table on metastore.. how can i able create that.. as i am
> not started hive server service, bcoz hadoop not installed on my syatem.
>
> --
> Thanks and
> Regards
>
> Rajendra Bhat
>
Re: Connect metadata
Posted by Gopal Vijayaraghavan <go...@apache.org>.
> Could someone provide me with a code snippet (preferably Java) that installs the schema (through datanucleus) on my empty metastore (postgres)
I wish it was that simple, but do not leave it to the Hive startup to create it - create it explicitly with schematool
https://cwiki.apache.org/confluence/display/Hive/Hive+Schema+Tool#HiveSchemaTool-TheHiveSchemaTool
or alternatively
https://github.com/apache/hive/blob/master/metastore/scripts/upgrade/postgres/hive-schema-2.2.0.postgres.sql
Cheers,
Gopal
Re: Connect metadata
Posted by Mich Talebzadeh <mi...@gmail.com>.
I don't understand what you mean by Hive installing your schema at startup.
If you have created an empty database/schema in postgres (I am not familiar
with it), you can run the relevant script in directory
$HIVE_HOME/scripts/metastore/upgrade/postgres
That will create all the associated tables and views in your schema and you
only need it once and the schema will be populated by hive user that you
have specified the details in hive-site.xml
HTH
Dr Mich Talebzadeh
LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
<https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*
http://talebzadehmich.wordpress.com
*Disclaimer:* Use it at your own risk. Any and all responsibility for any
loss, damage or destruction of data or any other property which may arise
from relying on this email's technical content is explicitly disclaimed.
The author will in no case be liable for any monetary damages arising from
such loss, damage or destruction.
On 25 October 2016 at 08:50, Per Ullberg <pe...@klarna.com> wrote:
> Sorry, no help from me I'm afraid, but I have a similar question:
>
> Could someone provide me with a code snippet (preferably Java) that
> installs the schema (through datanucleus) on my empty metastore (postgres).
> I don't want Hive to install the schema at startup, but rather do it
> explicitly myself.
>
> regards
> /Pelle
>
> On Tue, Oct 25, 2016 at 9:09 AM, Rajendra Bhat <ra...@gmail.com>
> wrote:
>
>> Hi Team,
>>
>> I have configured only meta store and started the meta store service,
>> hwich i ma used on presto.
>>
>> I need create table on metastore.. how can i able create that.. as i am
>> not started hive server service, bcoz hadoop not installed on my syatem.
>>
>> --
>> Thanks and
>> Regards
>>
>> Rajendra Bhat
>>
>
>
>
> --
>
> *Per Ullberg*
> Data Vault Tech Lead
> Odin Uppsala
> +46 701612693 <+46+701612693>
>
> Klarna AB (publ)
> Sveavägen 46, 111 34 Stockholm
> Tel: +46 8 120 120 00 <+46812012000>
> Reg no: 556737-0431
> klarna.com
>
>
Re: Connect metadata
Posted by Per Ullberg <pe...@klarna.com>.
Sorry, no help from me I'm afraid, but I have a similar question:
Could someone provide me with a code snippet (preferably Java) that
installs the schema (through datanucleus) on my empty metastore (postgres).
I don't want Hive to install the schema at startup, but rather do it
explicitly myself.
regards
/Pelle
On Tue, Oct 25, 2016 at 9:09 AM, Rajendra Bhat <ra...@gmail.com> wrote:
> Hi Team,
>
> I have configured only meta store and started the meta store service,
> hwich i ma used on presto.
>
> I need create table on metastore.. how can i able create that.. as i am
> not started hive server service, bcoz hadoop not installed on my syatem.
>
> --
> Thanks and
> Regards
>
> Rajendra Bhat
>
--
*Per Ullberg*
Data Vault Tech Lead
Odin Uppsala
+46 701612693 <+46+701612693>
Klarna AB (publ)
Sveavägen 46, 111 34 Stockholm
Tel: +46 8 120 120 00 <+46812012000>
Reg no: 556737-0431
klarna.com