Re: Hive beeline and ACID tables.

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

Re: Hive beeline and ACID tables.

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

Re: Hive beeline and ACID tables.

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

Re: Hive beeline and ACID tables.

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

Re: Hive beeline and ACID tables.

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

Re: Hive | Beeline access with multiple host port

Thanks... On 7 Dec 2015 10:33 pm, "Takahiko Saito" wrote: > Hi, > > You may be able to take advantage of dynamic service discovery: > > http://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.3.2/bk_hadoop-ha/content/ha-hs2-service-discovery.html > > On Mon, Dec 7, 2015 at 3:04 AM, Shashi Vishwakarma

Re: Hive | Beeline access with multiple host port

Hi, You may be able to take advantage of dynamic service discovery: http://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.3.2/bk_hadoop-ha/content/ha-hs2-service-discovery.html On Mon, Dec 7, 2015 at 3:04 AM, Shashi Vishwakarma wrote: > Hi > > down votefavorite >

Re: Hive BeeLine

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

Re: Hive BeeLine

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*