Unsubscribe

Sent from my iPhone

Unsubscribe

Re: Loading Sybase to hive using sqoop

Thank you all for valuable inputs On Wednesday, August 24, 2016, Mich Talebzadeh wrote: > If this is one off then Spark will do OK. > > Sybase IQ provides bcp that creates a flat file tab/comma separated and > you can use that to extract IQ table and put it on HDFS and create an > external table

Re: Loading Sybase to hive using sqoop

gt; > HTH > > > Dr Mich Talebzadeh > > > > LinkedIn * > https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw > <https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* > > > > http://talebzadehmich.wo

Loading Sybase to hive using sqoop

Hi All, We are trying to load data from Sybase Iq table to hive using sqoop. The hive table is partitioned and expecting to hold 29M records per day. The sqoop job takes 7 hours to load 15 days of data, even while setting the direct load option to 6. Hive is using MR framework. Is there is way t

Re: Inserting data in hive bucket

ction of data or any other property which may arise > from relying on this email's technical content is explicitly disclaimed. > The author will in no case be liable for any monetary damages arising from > such loss, damage or destruction. > > > > On 20 August 2016 at 23:53

Re: Inserting data in hive bucket

Hi Mich, I want to know If we can drop data of particular bucket in hive On Friday, August 19, 2016, Mich Talebzadeh wrote: > Hash partitioning (Bucketing) does not make much sense for /MM/DD/32 > as pointed out. > > So it is clear that with (mod 32), the maximum number of offsets is going

Re: Inserting data in hive bucket

o case be liable for any monetary damages arising from > such loss, damage or destruction. > > > > On 19 August 2016 at 21:46, Rahul Channe > wrote: > >> Hi , >> >> Is there a way to create the bucket with specific file name in hive. I >> see hive creates ra

Inserting data in hive bucket

Hi , Is there a way to create the bucket with specific file name in hive. I see hive creates random names for the file starting with I want the file name to be in mmdd format since I am partitioning by month and bucketing by date Thank you Rahul

Hive 0.14 startup error

Hi All, I am getting following error on starting hive 0.14. Need help user@ubuntuvm:~/hive-0.14.0$ hive Logging initialized using configuration in jar:file:/home/user/hive-0.14.0/lib/hive-common-0.14.0.jar!/hive-log4j.properties Exception in thread "main" java.lang.RuntimeException: java.lang.Ru

Re: oozie not running

3, 2015 at 7:00 PM, Rahul Channe > wrote: > >> Hi Mohammad, >> >> I checked the following path but did not find any hadoop jar >> >> /home/user/oozie-4.1.0/webapp/target/oozie-webapp-4.1.0/WEB-INF/lib >> >> user@ubuntuvm:~/oozie-4.1.0/webapp/target/oo

Re: oozie not running

n't include the correct hadoop jars? > Can you please check webapps/oozie/WEB-INF/lib directory for all hadoop > jars. If possible include the output of "ls hadoop*,jar" from that > directory. > > Regards, > Mohammad > > > On Sunday, February 22, 2015 2:45 PM,

Re: oozie not running

wrote: > could you check the oozie.log and catalina.out log file. It will give you > an idea what is wrong. > > ~Biswa > > > On Sun, Feb 22, 2015 at 1:22 PM, Rahul Channe > wrote: > >> Hi All, >> >> I configured the oozie build successfully and prepared o

oozie not running

Hi All, I configured the oozie build successfully and prepared oozie war file. After starting oozie when i tried to checkstatus its giving following error user@ubuntuvm:~/oozie-4.1.0/distro/target/oozie-4.1.0-distro/oozie-4.1.0$ bin/oozie admin -oozie http://localhost:11000/oozie -statusConnectio

Re: [ANNOUNCE] New Hive PMC Member - Prasad Mujumdar

Congrats Prasad On Wednesday, December 10, 2014, Thejas Nair wrote: > Congrats Prasad! > > > On Tue, Dec 9, 2014 at 5:03 PM, Navis류승우 > wrote: > > Congratulations! > > > > 2014-12-10 8:35 GMT+09:00 Jason Dere >: > >> > >> Congrats! > >> > >> On Dec 9, 2014, at 3:02 PM, Venkat V > > wrote: > >>

Oozie job not running

Hi All, I am trying to run my oozie job but its giving below error user@ubuntu:~/hive_oozie$ oozie job -oozie http://ubuntu:11000/oozie -config job.properties -run Error: E0501 : E0501: Could not perform authorization operation, Call From ubuntu/192.168.31.130 to localhost:8020 failed on connect

Re: oozie workflow error

Hi Nagarjuna, I have attached the requested file. On Sun, Sep 28, 2014 at 10:35 PM, Nagarjuna Vissarapu < nagarjuna.v...@gmail.com> wrote: > Can u pls attach workflow and properties file > On Sep 29, 2014 7:01 AM, "Rahul Channe" wrote: > >> hi All, >>

oozie workflow error

hi All, I am unable to run oozie workflow, please help user@ubuntu:~/hive_oozie$ oozie job -oozie http://localhost:11000/oozie -config job.properties -run Error: E0501 : E0501: Could not perform authorization operation, Failed on local exception: java.io.EOFException; Host Details : local host is

Re: oozie installation error

2014 at 7:42 AM, Muthu Pandi wrote: > replace hadoop-2 with hadoop-1 > > > > *RegardsMuthupandi.K* > > Think before you print. > > > > On Thu, Sep 25, 2014 at 4:48 PM, Rahul Channe > wrote: > >> Hi Muthu, >> >> I am trying to build oozie ag

Re: oozie installation error

ipTests > > if you are building against hadoop 2 > > it resolved the distro error. > > For more info follow "http://gauravkohli.com/category/oozie/"; > > > > *RegardsMuthupandi.K* > > Think before you print. > > > > On Wed, Sep 24, 2014 a

oozie installation error

hi All, I am trying to install oozie and getting following error. Any input is appreciated [INFO] BUILD FAILURE [INFO] [INFO] Total time: 18.326s [INFO] Finished at: Wed Sep 24 13:45:13 EDT 2014 [INFO] Final Memory: 26M/64M

Re: Oracle backend for Hive Metastore

; > Did you explicitly create the tables in the metastore via the Oracle > script or depend on DataNucleus to do it for you? > > Alan. > > Rahul Channe > September 22, 2014 at 10:47 > Hi All, > > I am using oracle as hive metastore. I could see the schema create

Oracle backend for Hive Metastore

Hi All, I am using oracle as hive metastore. I could see the schema created in oracle after logging into hive and executing create database command successfully. When i am trying to create table in hive its throwing error, please help hive> create table test ( name string,age int) row format de

Re: Column value incorrect in hive xml table

quot;:"DEPENDANT","IsPrimary":"true","GroupID":"9898989","GroupName":""} > 02573768-01 > > {"LastName":"P","Gender":"F","DateOfBirth":"1999-01-01&

Column value incorrect in hive xml table

Hi All, I am using hivexmlserde-1.0.5.1.jar to load xml data into hive table. Following is the table DDL create external table h_xml (member_id string,personal_identity map,personal_contact map,Enrollment map ) row format serde 'com.ibm.spss.hive.serde2.xml.XmlSerDe' with SERDEPROPERTIES ( "colum

Re: error on show databases

t; Thanks, > Divakar > > > On Wed, Aug 6, 2014 at 9:13 PM, Rahul Channe > wrote: > >> Hi All, >> >> I am getting following error >> >> hive> show databases; >> FAILED: Execution Error, return code 1 from >> org.apache.hadoop.hi

error on show databases

Hi All, I am getting following error hive> show databases; FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient hive> Regards, Rahul

Change default meta store location

Hi All, Whenever I am logging to hive from any directory it's creating new metastore_db I also update the hive-default.xml to change the metastore location to different location but it's not working Any help appreciated Rahul

Re: Hive User Group Meeting

I am staying in New Jersey, would be able to help over weekend and during event days Please consider me in host committee On Monday, July 7, 2014, Xuefu Zhang wrote: > Dear Hive users, > > Hive community is considering a user group meeting during Hadoop World > that will be held in New York Oc

Re: Behaviour of distinct clause

How does it matter , you are running distinct on name and age so one record is displayed If you add file name in you select then hopefully you will get what you are looking for On Thursday, June 5, 2014, Bala Krishna Gangisetty wrote: > Could you paste the "describe " output? > > --Bala G. > >

Data enclosed in Double quotes

Hi All, I have data enclosed in doubles quotes, is there a way in HIVE create table syntax to tell hive that data is enclosed in double quotes. in oracle we have - OPTIONALLY ENCLOSED "," Regards, Rahul

Re: java.lang.TypeNotPresentException: Type timestamp not present

Try loading the data in a temporary hive table with datatype as String, then you can populate the data in the final table insert into table timestamp_example select from_unixtime(unix_timestamp(v_time ,'MM/dd/ HH:mm') ) from timestamp_example_temp; On Mon, Jun 2, 2014 at 3:23 PM, Patcharee

login Error on Hive 0.13.0

Hi All, I am trying to login to HIVE and getting following error user@localhost:~$ hive 14/05/28 16:42:04 WARN conf.HiveConf: DEPRECATED: hive.metastore.ds.retry.* no longer has any effect. Use hive.hmshandler.retry.* instead Logging initialized using configuration in jar:file:/home/user/apache

Re: HiveServer2 with Hive CLI

You can try running derby in multi session mode. I did that , now I can use Hive web interface and hive CLI simultaneously On Wednesday, May 28, 2014, Amjad ALSHABANI wrote: > OOps, I forgot about that :) > > Thanks Dima to mention that. > > Actually where I m doing the test using Derby but on

Re: Unable to load data in hive table

t; > > On Mon, May 19, 2014 at 7:02 PM, Rahul Channe wrote: > >> I have created the following partitioned table in hive >> >> create table custs ( cust_id int, first_name String,last_name >> String,cust_age int ) partitioned by ( cust_prof String) row format >>

Unable to load data in hive table

I have created the following partitioned table in hive create table custs ( cust_id int, first_name String,last_name String,cust_age int ) partitioned by ( cust_prof String) row format delimited fields terminated by ','; when I am trying to load data into the table, I am getting error load dat