Search Results

I am sorry for not stating my requirement properly , We are trying to accomplish incremental load of data by comparing two files

File 1
id | text | email id ...

I have a below requirement and trying to compare the files using awk



File 1 - Already stored on a prev day
id | text | email id
---------------------------------...

Thank you Akshay , this worked like magic !!!! :b:

Hello Alister,

Sorry for my delay response , I am running Linux (2.6) . Below is the error message I am receiving when running as


perl test.pl
syntax error at test.pl line 1, near...

Hi Ahmed,
The latest output which I shared is the output which I am looking for I got confused with my output with the first time . Hope I answered your question if not please let me know.
...

Thanks Akshay for the code , Apologies for not mentioning the delimeter but you had it right pipe delimiter is the one which I thought as well .
Also I think I got confused with my input and output...

Hi Team,

I am trying to get the data in below format


Jan 01 | 19:00:32 | xyz | abc | sometext | string


however I am not sure of the total number strings which can come in the record...

Thanks Blake , I was able to get the output by running at the command line however if I save it in a file and execute it I am getting error . Let me know if any changes need to be done if I had to...

Thank you Jethrow for the code , I am still very new to Perl I am fiddling around . Could you let me know what wrong I am doing when executing the query .


perl -ne '...

Hi All ,

I have a file with below data
# User@Host: xyz @ [ipaddress]
# Query_time: t1 Lock_time: t2 Rows_sent: n1 Rows_examined: n2
SET timestamp=1396852200;
select count(1) from table;...

Hi Team ,

I have a new server which needs to be made as datanode for my existing single node cloudera setup .

I did gone through some of the online documentation and most of them said to...

Currently my cloudera env is a single server ( Name node and Data node on the same server ) , Now i would like to create another Name node for HA purpose and configure zookeeper to Automate HA ,...

Thanks Ravinder but i am looking something in Pig Latin syntax , I am trying to process the data in Hadoop using PigLatin.

Appreciate if you can suggest the same code in Pig Latin.Programming

Hello ,

I have a sample file with below information
Ipaddress , time
-------------------
ipaddress-1,10:58
ipaddress-1,11:50
ipaddress-1-10:58
ipaddress-2,11:50
ipaddress-2,10:58...

Hi ,

I am trying to setup HIVE ODBC with below setting

Host: Local host
port : 10000
Database : Default
Hive server type : Hive server 2
Mechanism: User

But getting below error:...

Ya Neo , I did try that i tried to edit the file hue.ini but was not able to resolve the issue . I am guessing that there is another file where i need to add the LDAP entry or to disable it . Which i...

Hi Neo,

Thank you for your response.

I am new to LDAP and HUE as well , can you let me know what file should i need to edit to give entries for LDAP and what would it be like .

Hi ,

I have installed Cloudera Hadoop successfully however when i am launching the web page for HUE , I am receiving below error message.

Configuration files located in...

I am trying to install EEM on Linux but found with below issue


27 Sep 2013 01:10:41 INFO iGateway - Check if we can upgrade from Linux 2.4 to 2.6 installer
27 Sep 2013 01:10:41 INFO iGateway...

I am trying to upgrade Autosys to r11.3.5 how ever while running the setup i am getting below error , I went through some of the Known errors , found to command the export LD_ASSUME_KERNEL parameter...

I have infact tried with grep -w xyz *.filename but the problem here is since i have huge data to be processed its taking days to get my output. Is there any faster means of searching in unix than...

Hi All,

I have a issue in pulling some heavy records , I have my input file has 10,000 records which i need to compare with daily appended log files from (sep 1st 2009 to till date) . I tried to...