Re: May 2018 Hive User Group Meeting

2018-05-02 Thread Ajay Chander
+1 for streaming or a recording. Thanks On Wed, May 2, 2018 at 10:54 AM Elliot West wrote: > +1 for streaming or a recording. Content looks excellent. > > On 2 May 2018 at 15:51, dan young wrote: > >> Looks like great talks, will this be streamed anywhere? >> >> On Wed, May 2, 2018, 8:48 AM Sah

Re: HIVE on Windows

2016-08-24 Thread Ajay Chander
Hi, Were you able to get Hive up and running on Windows machine ? I have installed Hadoop on Windows now I want to install Hive too. I couldn't find binaries to run on Windows machine. Can anyone tell me is it possible to run Hive on Windows machine ? Thanks On Wednesday, May 18, 2016, Me To wro

ELK_on_Hive

2016-08-15 Thread Ajay Chander
Hi Team, I would like to get your opinion on implementing ELK on Hive. Right now, we have some tables in Hive and we would like to visualize those tables/generate a reports. Is ELK known to do this kind of stuff or what would you recommend ? Thanks - Aj

Re: External_Tables_Disadvantages

2016-06-28 Thread Ajay Chander
Hi Team, Any insights on this one? Thank you On Monday, June 27, 2016, Ajay Chander wrote: > Hi Everyone, > > I would like to know the disadvantages of using External tables in Hive. I > was told that "Managing security with sentry will be very limited for > external tab

External_Tables_Disadvantages

2016-06-27 Thread Ajay Chander
Hi Everyone, I would like to know the disadvantages of using External tables in Hive. I was told that "Managing security with sentry will be very limited for external tables" is it true? Can someone explain it please? Thank you. Regards, Aj

Re: Sqoop_Sql_blob_types

2016-04-27 Thread Ajay Chander
e later case you should > think about an optimal analysis format in Hive. > > > On 27 Apr 2016, at 22:13, Ajay Chander > wrote: > > > > Hi Everyone, > > > > I have a table which has few columns as blob types with huge data. Is > there any best way to &

Re: Sqoop_Sql_blob_types

2016-04-27 Thread Ajay Chander
edin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw > <https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* > > > > http://talebzadehmich.wordpress.com > > > > On 27 April 2016 at 21:13, Ajay Chander > wrote: > >> Hi Everyone, >> >> I

Sqoop_Sql_blob_types

2016-04-27 Thread Ajay Chander
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: Data_encyption(rdbms_to_hive)

2016-04-19 Thread Ajay Chander
This is to understand if sqoop has the capability to encrypt the data in transit from Man in the Middle attacks? Any pointers are appreciated. Thanks On Tuesday, April 19, 2016, Ajay Chander wrote: > Hi Everyone, > > I am just trying to understand if there is any default 'dat

Data_encyption(rdbms_to_hive)

2016-04-19 Thread Ajay Chander
Hi Everyone, I am just trying to understand if there is any default 'data encryption/decryption' involved when we sqoop the data from rdbms to hive. If there is so, can someone point me to a material which reads about it? Thanks for your time! Regards, Aj

Hive support in oozie shell action

2016-04-06 Thread Ajay Chander
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: Hive_primary_key

2016-03-30 Thread Ajay Chander
> Thanks > > Hari > ---------- > *From:* Ajay Chander > > *Sent:* Wednesday, March 30, 2016 11:33 AM > *To:* user@hive.apache.org > > *Subject:* Hive_primary_key > > Hi Users, > > Just wanted to check if the support for defining primary

Hive_primary_key

2016-03-30 Thread Ajay Chander
Hi Users, Just wanted to check if the support for defining primary keys(constraints) while creating a hive external tables is available yet? Thank you!

Re: De-identification_in Hive

2016-03-20 Thread Ajay Chander
ER > 0 AND > CAST(REGEXP_REPLACE(total,'[^\\d\\.]','') AS DECIMAL(20,2)) > 0.0 > -- Exclude empty rows > > HTH > > Dr Mich Talebzadeh > > > > LinkedIn * > https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw >

De-identification_in Hive

2016-03-19 Thread Ajay Chander
Hi Everyone, I have a csv.file which has some sensitive data in a particular column in it. Now I have to create a table in hive and load the data into it. But when loading the data I have to make sure that the data is masked. Is there any built in function is used ch supports this or do I have to

Re: De-identification_in Hive

2016-03-19 Thread Ajay Chander
Tustin, Is there anyway I can deidentify it in hive ? On Thursday, March 17, 2016, Marcin Tustin wrote: > This is a classic transform-load problem. You'll want to anonymise it once > before making it available for analysis. > > On Thursday, March 17, 2016, Ajay Chander

Re: De-identification_in Hive

2016-03-19 Thread Ajay Chander
zadehmich.wordpress.com > > > > On 17 March 2016 at 15:14, Ajay Chander > wrote: > >> Mich thbaks for looking into this. I have a 'csvfile.txt ' on hdfs. I >> have created an external table 'xyz' to load that data into it. One of the >>

Re: De-identification_in Hive

2016-03-19 Thread Ajay Chander
ile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw > <https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* > > > > http://talebzadehmich.wordpress.com > > > > On 17 March 2016 at 14:37, Ajay Chander > wrote: > >> Tustin, Is there anyway I

Re: De-identification_in Hive

2016-03-19 Thread Ajay Chander
> > > On 17 Mar 2016, at 14:58, Ajay Chander > wrote: > > > > Hi Everyone, > > > > I have a csv.file which has some sensitive data in a particular column > in it. Now I have to create a table in hive and load the data into it. But > when loading the data

Re: Hive_CSV

2016-03-09 Thread Ajay Chander
rtType from csvtab; > > Daniel > > > On 9 Mar 2016, at 19:43, Ajay Chander > wrote: > > > > Hi Everyone, > > > > I am looking for a way, to ignore the first occurrence of the delimiter > while loading the data from csv file to hive external table.

Re: Hive_CSV

2016-03-09 Thread Ajay Chander
mns for querying? > Alternatively use regular expressions. > > > > > On 09 Mar 2016, at 18:43, Ajay Chander > wrote: > > > > Hi Everyone, > > > > I am looking for a way, to ignore the first occurrence of the delimiter > while loading the data from csv file

Hive_CSV

2016-03-09 Thread Ajay Chander
Hi Everyone, I am looking for a way, to ignore the first occurrence of the delimiter while loading the data from csv file to hive external table. Csv file: Xyz, baseball, outdoor Hive table has two columns sport_name & sport_type and fields are separated by ',' Now I want to load by data into