Re: Unsubscribe

Safdar Kureishy and Mark Memory, to unsubscribe from this mailing list please send a message to user-unsubscr...@hive.apache.org as described here: Mailing Lists . Thanks. -- Lefty On Tue, Aug 23, 2016 at 9:49 PM, Safdar Kureishy wrote: > >

Re: Request for write access to hive wiki

Done. Welcome to the Hive wiki team, Kit! -- Lefty On Tue, Aug 23, 2016 at 12:44 PM, Kit Menke wrote: > I am requesting write access to the hive wiki. My confluence user name is > kit.menke.

IP address always got "unknown-ip-addr" in hive audit log

Hi, all:    I want to config audit log for hive 1.2.1. I use kerberos for hive authentication, and did not start up the hive metastore service. Just under such a background，I opened hive autid-log function. But the log contents like this: "HiveMetaStore.java:logAuditEvent(371) - ugi=ocp i

Re:Re: why need set hive.server2.enable.doAs=false in SQL-Standard Based Authorization

Thankyou so much,Sushanth. I GOT IT ( :) ) At 2016-08-20 07:24:10, "Sushanth Sowmyan" wrote: >One more addition to what Thejas mentioned - >BitSetCheckAuthorizationProvider was the old legacy method of >authorization in hive that was replaced in use-intent by >SQLStandardAuthorization. I thin

unsubscribe

Unsubscribe

Select Column, UDF(Column) from table Column is also been converted to UDF(Column)

Hi, I have been using Hive UDF for a while, and in hive 1.* versions, I found original column is been overwritten. Is this a hive bug? If true, in which of the versions are fixed? Thanks, Fan

Loading Sybase to hive using sqoop

Hi All, We are trying to load data from Sybase Iq table to hive using sqoop. The hive table is partitioned and expecting to hold 29M records per day. The sqoop job takes 7 hours to load 15 days of data, even while setting the direct load option to 6. Hive is using MR framework. Is there is way t

Re: Hive transaction doesn't release lock.

your query is "select * from HIVE_LOCKS" but the output is not from HIVE_LOCKS. What entries do you have in HIVE_LOCKS for this txn_id? If all you see is an entry in TXN table in 'a' state - that is OK. that just mean that this transaction was aborted. Eugene From: Igor Kuzmenko mailto:f1she..

Request for write access to hive wiki

I am requesting write access to the hive wiki. My confluence user name is kit.menke.

Re: How to remove Hive table property?

Has table got data in it? Can you create a new table WITHOUT serialization.null.format and INSERT/SELECT from old to new, drop old and rename new to old. If the data is already there then the setting will apply to new rows only. That may be acceptable. HTH Dr Mich Talebzadeh LinkedIn * http

How to remove Hive table property?

I've created a Hive table with property "serialization.null.format"="null" to interpret string "null' as null. Now it's unnecessary for me. How can I remove it? Alter table properties page

Re: Hive transaction doesn't release lock.

Hi Igor, I don't think so. Well I never raised one! HTH Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw * http://talebzadehmich.wordpress.com

Re: Hive transaction doesn't release lock.

Thanks for reply, Mich. Is there any open item in Jira? On Mon, Aug 22, 2016 at 9:28 PM, Mich Talebzadeh wrote: > there are issues with locks not being released even when the transaction > is aborted. There are still entries in hive_locks. > > I ended up deleting the row from hive_locks table ma