gt; other relevant properties) hive-site.xml so that all sessions agree on
> which lock manager/txn manager they are using.
>
>
>
> Eugene
>
>
>
> *From: *Colin Williams
> *Reply-To: *"user@hive.apache.org"
> *Date: *Thursday, February 15, 2018 at 8:54 AM
properties) hive-site.xml so that all sessions agree on which lock manager/txn
manager they are using.
Eugene
From: Colin Williams
Reply-To: "user@hive.apache.org"
Date: Thursday, February 15, 2018 at 8:54 AM
To: "user@hive.apache.org"
Subject: Re: Hive beeline and ACID tab
Looking back I may have omitted the --hiveconf setting. I will try creating
the table again today and see if that was the issue.
On Thu, Feb 15, 2018 at 8:51 AM, Colin Williams <
colin.williams.seat...@gmail.com> wrote:
> Hi Johannes. I did set the "transactional" property to true like:
>
> tblpr
Hi Johannes. I did set the "transactional" property to true like:
tblproperties("transactional"="true");
And also stored as orc and bucketed and partitioned the table. Finally I
did use double -- for setting the hiveconf. Then there must be some other
issue regarding using the ACID tables.
On
Hi Collin,
you need to set the table property “transactional” to true, this will mark the
table as ACID.
See also the example all the way at the bottom of this link.
https://cwiki.apache.org/confluence/display/Hive/Hive+Transactions
For your error, the SELECT, maybe it is simply a copy-n-paste
Hello,
I'm new to hive and had been porting some Redshift SQL to Hive. Today I ran
across a table that uses update.
After a somewhat time consuming translation process I was able to load the
create table definition. However the update part returned an error about
update not supported on non-acid
when I start the metastore thrift
service and set hive.metastore.uris in hive-site.xml, this problem no longer
appears: No matter Hive CLI, Hive Beeline or SparkSession altered a table,
others can see the correct new table schema.
I have two questions here:
1. According to
https
Dec 7, 2015 at 3:04 AM, Shashi Vishwakarma <
> shashi.vish...@gmail.com> wrote:
>
>> Hi
>>
>> down votefavorite
>> <http://stackoverflow.com/questions/34131860/hive-beeline-access-with-multiple-host-port#>
>>
>> Usually connecting HiveServer2 using
ackoverflow.com/questions/34131860/hive-beeline-access-with-multiple-host-port#>
>
> Usually connecting HiveServer2 using beeline we pass hostnaime1 and port
> as connection property?
>
> Can we configure beeline in such a way that if my primary hostname is down
> then it should go f
Hi
down votefavorite
<http://stackoverflow.com/questions/34131860/hive-beeline-access-with-multiple-host-port#>
Usually connecting HiveServer2 using beeline we pass hostnaime1 and port as
connection property?
Can we configure beeline in such a way that if my primary hostname is down
t
Hi Noam,
The file exist on my machine.. I can do cat,ls,ll etc on it.
On Mon, Jul 6, 2015 at 2:31 AM, Noam Hasson wrote:
> Just making sure, LOAD DATA LOCAL INPATH loads files from your local file
> system, did you make sure the file exist on your machine?
>
> On Mon, Jul 6, 2015 at 12:15 PM, T
Just making sure, LOAD DATA LOCAL INPATH loads files from your local file
system, did you make sure the file exist on your machine?
On Mon, Jul 6, 2015 at 12:15 PM, Trainee Bingo
wrote:
> Hi Users,
>
> I have Hive and HiveServer2 on the same machine. But, when I try to *LOAD
> DATA LOCAL INPATH*
Hi Users,
I have Hive and HiveServer2 on the same machine. But, when I try to *LOAD
DATA LOCAL INPATH* using BeeLine I get "Invalid Path Error" and if I do
LOAD DATA INPATH it takes it successfully.
Can anyone pls tell me why local inpath does not work??
Thanks,
Trainee.
13 matches
Mail list logo
