Hive SQL query

Hi, Is there any SQL query or command to create server in Hive. Also please let me know any API for creating server and retrieving server info in JDBC. Thanks Braj

Hive support in oozie shell action

Hi Everyone, I am trying to execute a hive script in oozie shell action like below, Action failed, error message[${wf:errorMessage(wf:lastErrorNode())}] ${jobTracker} ${nameNode} /user/hue/oozie/workspaces/hue-oozie-1459982183.04/b.sh /user/hue/oozie/workspaces/hue-oozie-1459982183.04/b.sh#

Re: Sqoop on Spark

Sorry are you referring to Hive as a relational Data Warehouse in this scenario. The assumption here is that data is coming from a relational database (Oracle) so IMO the best storage for it in Big Data World is another DW adaptive to SQL. Spark is a powerful query tool and together with Hive as a

How to use Spark JDBC to read from RDBMS table, create Hive ORC table and save RDBMS data in it

Hi, There was a question on the merits of using Sqoop to ingest data from Oracle table to Hive. The issue is that Sqoop reverts to MapReduce when getting data into Hive which is not that great. One can do IMO better by using JDBC connection (which is identical with what Sqoop does anyway but cruc

Re: analyse command not working on decimal(38,0) datatype

plus the version of version of Hive Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw * http://talebzadehmich.wordpress.com On 6 April 2016 at 16

Re: Hive wiki write access request

Done. Thanks, Ashutosh On Wed, Apr 6, 2016 at 6:22 AM, Random Suit wrote: > Putting in a request for write access on the Hive wiki. My confluence > username is "therandomsuit". > > Thanks. >

Re: analyse command not working on decimal(38,0) datatype

Please provide exact log messages , create table statements, insert statements > On 06 Apr 2016, at 12:05, Ashim Sinha wrote: > > Hi Team > Need help for the issue > Steps followed > table created > Loaded the data of lenght 38 in decimal type > Analyse table - for columns gives error like zero

Hive wiki write access request

Putting in a request for write access on the Hive wiki. My confluence username is "therandomsuit". Thanks.

DAG Kill while insert into A select * from B

Hi. I have trouble to run query "insert into table mylog_orc_bucketing select * from mylog_orc" *Job received Kill while in RUNNING state.Vertex killed, vertexName=Map 1, vertexId=vertex_1459773554571_0009_10_00, diagnostics=* * Vertex received Kill while in RUNNING state., Vertex did not succe

RE: Best way of Unpivoting of hiva table data. Any Analytic function for unpivoting

You can do something like this: select id,key,value from my_table lateral view explode (map('fname',first_name,'lname',last_name)) t; Given the following table: id, first_name,last_name __ 1,Dudu,Markovitz 2,Andrew,Sears The result will look like: Id,key,value

Re: HBase table map to hive

If your schema is changing frequently I think it's better to use Avro for schema evolution, and go with 'Avro Serde' with 'AvroContainerInputFormat' & 'AvroContaineOutputFormat' for creating table in Hive from Hbase. On Mon, Apr 4, 2016 at 1:19 PM, Wojciech Indyk wrote: > Hi! > You can use map