AuthorizationException while exposing via JDBC client (beeline)

Hi, I wrote a spark job which registers a temp table and when I expose it via beeline (JDBC client) $ *./bin/beeline* beeline> * !connect jdbc:hive2://IP:10003 -n ram -p *0: jdbc:hive2://IP> *show

Re: Sqoop_Sql_blob_types

Thanks Franke! Probably now I don't want to move the data directly into Hive. My SQL database contains a table 'test' with 2 Columns(file_name char(100) ,file_data longblob). Column 'file_data' may contain xml formatted data or pipe delimited data and its huge amount of data. Right now I am

Re: Sqoop_Sql_blob_types

You could try as binary. Is it just for storing the blobs or for doing analyzes on them? In the first case you may think about storing them as files in HDFS and including in hive just a string containing the file name (to make analysis on the other data faster). In the later case you should

get version number of hive-contrib in HQL

Hi, For generating row sequencing, we are using Hive-contrib library in Hive Script. We are using "ADD JAR /apps/dist/hive-1.2.1.2.3.3.1-5/lib/hive-contrib-1.2.1.2.3.3.1-5.jar"; and creating temporary function CREATE TEMPORARY FUNCTION rwSequenceid AS

Re: Sqoop_Sql_blob_types

Mich thanks for looking into this. At this point of time the source is MySQL. Thank you! On Wednesday, April 27, 2016, Mich Talebzadeh wrote: > Is the source of data Oracle? > > Dr Mich Talebzadeh > > > > LinkedIn * >

Re: Sqoop_Sql_blob_types

Is the source of data Oracle? Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw * http://talebzadehmich.wordpress.com On 27 April 2016 at 21:13,

Sqoop_Sql_blob_types

Hi Everyone, I have a table which has few columns as blob types with huge data. Is there any best way to 'sqoop import' it to hive tables with out losing any data ? Any help is highly appreciated. Thank you!

Re: Hive TTransportException - Create Table

Hi, When you state: "The Queries are dependent on certain table which are created on Runtime(refreshed every hour), .." What is refreshed the whole of DDL for the same table or table is truncated? If these tables are created and dropped within the same session why not use temporary tables

Hive TTransportException - Create Table

Hi All, I am running Hive Server2 on a big Hadoop cluster space and things looks good, I have a custom code which takes care of running some queries on top of Hive and processing the resultant accordingly. The Queries are dependent on certain table which are created on Runtime(refreshed every

RE: Question on Implementing CASE in Hive Join

I feel the mail at your end has got a different format. Remove * and - in the data what you see...That is my final dataYou can correlate with B 2. I need A LeftJoin B On Apr 27, 2016 11:41 PM, "Markovitz, Dudu" wrote: > Huston, we have a problem J > > > > 1. > > Data

Re: Question on Implementing CASE in Hive Join

Hello Dudu, Thank you for previous reply. I tried all the scenarios but nothing is working out. I need this condition with with minimal steps like by using case when. Please find the below TableA Code CountryType Flag 101 US TaxX 101 USA TaxY 101 CA Tax

Hive thrift server stops responding

Hi, We are using hive 0.13.1 and Hadoop 2.3.0. There are multiple process connecting through jdbc and thrift client. Recently we have observed a strange behaviour where in it stops responding. There is nothing logs to figure out what is wrong everything seems to be normal. There is enough free