Re: Hive alternatives?

I agree with the suggestions presented already. You may want to check presto as an alternative as well. But please remember , Presto is an added layer on top of Hive and not an independent alternative. It simplifies your semantic layer and querying while being faster than Hive. For OLAP , I will al

Question of List Bucketing Table

Hi all , I try to create List Bucketing Table in Hive 0.13.1 as bellow , set hive.mapred.supports.subdirectories=true; set hive.exec.dynamic.partition=true; set hive.exec.dynamic.partition.mode=nonstrict; set hive.input.format=org.apache.hadoop.hive.ql.io.BucketizedHiveInputFormat; set hive.mer

Re: Hive alternatives?

1) Apache Phoenix + Mondrian 2) Apache Spark On Thu, Nov 5, 2015 at 2:49 PM, Jörn Franke wrote: > First it depends on what you want to do exactly. Second, Hive > 1.2, Tez > as an Execution E

Re: Hive alternatives?

First it depends on what you want to do exactly. Second, Hive > 1.2, Tez as an Execution Engine (I recommend >= 0.8) and Orc as storage format can be pretty quick depending on your use case. Additionally you may want to employ compression which is a performance boost once you understand how stor

Hive alternatives?

Hello, I was looking for Hive as OLAP alternative, but I've read that is quite slow for that, does anybody have experiences about? or a Hive altenative for OLAP? Killin is not an option becouse we need dynamic OLAP like ROLAP Regards, -- Ing. Ivaldi Andres

Re: Hive function to convert numeric IP address to "dot" format?

Thanks Mark Ohh, that was long to ip conversion. I thought, ip (dots) has been removed some where. Love to hear from you. Cheers On Thu, Nov 5, 2015 at 9:05 PM, Mark Sunderlin wrote: > Actually, I found a UDF that does this very nicely! > > > https://github.com/petrabarus/HiveUDFs/blob/master

Re: Hive function to convert numeric IP address to "dot" format?

Actually, I found a UDF that does this very nicely! https://github.com/petrabarus/HiveUDFs/blob/master/src/main/java/net/petrabarus/hiveudfs/LongToIP.java Share and enjoy! -- Mark E. Sunderlin Data Architect // Data Solutions P: 703-265-6935 // C: 540-327-6222 // 22000 AOL Way, Dulles, VA 2016

Re: How to set add jar jarpath within hive jdbc query?

You can move your auxiliary jars to some hdfs location. And use that path instead of local path. Thanks, Chetna Chaudhari On 5 November 2015 at 19:13, Suresh Kumar Sethuramaswamy wrote: > You can try adding it in hive/lib location on all the cluster nodes. You > dont need to add it part of your

Re: How to set add jar jarpath within hive jdbc query?

You can try adding it in hive/lib location on all the cluster nodes. You dont need to add it part of your query On Thu, Nov 5, 2015 at 3:59 AM, Lee S wrote: > Hi all: > I try to execute hive query in a remote client through hive server2 jdbc. > > I want to 'add jar' used as serde before crea

How to set add jar jarpath within hive jdbc query?

Hi all: I try to execute hive query in a remote client through hive server2 jdbc. I want to 'add jar' used as serde before create a table. But when I set the jar path local to the hive server host, it said the jar does not exist. And when I set the jar in the client , it said failed to rea