ORC file-format partition elimination

2013-12-05 Thread Xiu Guo
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!

Re: How to prevent user drop table in Hive metadata?

2013-11-22 Thread Xiu Guo
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,

Re: Data file and table def different number of columns

2013-10-24 Thread Xiu Guo
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

Re: Where clause position

2013-10-17 Thread Xiu Guo
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

Where clause position

2013-10-16 Thread Xiu Guo
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

Running Hive JDBC Server1 and Server2 Concurrently

2013-10-01 Thread Xiu Guo
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

Error while running junit test for hive in eclipse

2013-09-27 Thread Xiu Guo
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

Case When ... Else... Type Restriction

2013-08-22 Thread Xiu Guo
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