A quick question:
Does Hive-0.11 support partition elimination for ORC files by default? Or
does anything have to be set in configuration settings?
Thanks!
Does something like this not do the job?
property
namehive.security.authorization.createtable.user.grants/name
valueuser1:select;user2:create/value
/property
I thought tweaking hive-site.xml would be fine.
On Fri, Nov 22, 2013 at 3:06 PM, Echo Li echo...@gmail.com wrote:
Thanks all,
fields.
you dig?
On Wed, Oct 23, 2013 at 4:53 PM, Xiu Guo xgu...@gmail.com wrote:
We have a table called employee.dat with below contents:
1,ryan,d'souza,it,2
2,michael,fernandes,admin,25000
then in Hive, query:
create table myTbl (a INT, b STRING)
ROW FORMAT DELIMITED
FIELDS
eson...@liveperson.com wrote:
Would it be possible to simply this query removing as much as possible
keeping just enough to demonstrate the where issue.
** **
On Wed, Oct 16, 2013 at 2:22 PM, Xiu Guo xgu...@gmail.com wrote:
The following query does not work:
SELECT
The following query does not work:
SELECT
T1.ACCOUNT_NUM
,T1.ACCOUNT_MODIFIER_NUM
,T1.DEPOSIT_TYPE_CD
,T1.DEPOSIT_TERM
,CASE
WHEN T1.DEPOSIT_TYPE_CD='5021' THEN
'9255'
ELSE
CASE
WHEN T4.LEDGER_SUBJECT_ID_01= '' THEN ''
ELSE COALESCE(T4.LEDGER_SUBJECT_ID_01,'')
END
END
Hi,
I understand in Hive 0.11 the default JDBC server is server2. Is it
possible to run the old server1 and new server2 concurrently so it takes
different version of client access?
If possible, what should be added in hive-site.xml?
Thank you!
Xiu
I compiled Hive trunk source code using:
ant clean package eclipse-files
and run a junit test on command line just fine:
ant test -Dtestcase=TestCliDriver -Dqfile=auto_join25.q -Dmodule=ql
-Dtest.silent=false
However, when imported into eclipse and run the same test, it throws
Hello:
Can someone clarify this for me?
In CASE a WHEN b THEN c [ELSE f] END, are the following rules necessary?
1. a and b should have the same TypeInfo, or an exception will be thrown.
2. c and f should have the same TypeInfo, or an exception will be thrown.
Right now, even if c is int, f is