RE: FAILED: ClassCastException org.apache.hadoop.io.Text cannot be cast to java.lang.String

2014-08-01 Thread Ricardo Birmele
Hi Dan, Take a look at this: http://javarevisited.blogspot.com/2012/12/how-to-solve-javalangclasscastexception-java.html __Birm Ricardo Birmele, CISSP Security Data Scientist Microsoft IT Security Operations * | | * [Microsoft Logo] From: Dan Fan [mailto:d...@appnexus.com] Sent: Friday

Re: Install Hadoop and Hive

2014-07-28 Thread Ricardo Birmele
he Windows Powershell http://technet.microsoft.com/en-us/library/hh847837.aspx#BKMK_InstallingOnWindows7andWindowsServer2008R2 does not seem to do that. On Sunday, July 27, 2014 8:22 PM, Ricardo Birmele mailto:ricardo.birm...@microsoft.com>> wrote: You can use PowerShell to run

Re: Install Hadoop and Hive

2014-07-27 Thread Ricardo Birmele
You can use PowerShell to run Hive commands, real easy. And free, if I'm not mistaken. Sent from my mobile... On Jul 27, 2014, at 5:55 PM, "R J" mailto:rj201...@yahoo.com>> wrote: Hi All, I have Windows PC (Windows 7, 64bit). I tried to install Apache Hadoop in the past but could not succee

RE: Help with query

2014-06-06 Thread Ricardo Birmele
One quick suggestion…if you modify the query to this: SELECT COUNT(DISTINCT ip) AS IP_count, IP, query_string FROM myTable GROUP BY IP, query_string ORDER BY count DESC; …then you should see each IP along with its count. FWIW, __Birm Ricardo Birmele, CISSP Senior Security Technologist Microsoft

RE: alter table add more columns

2014-06-03 Thread Ricardo Birmele
the last few columns?) · File layout (how do I lay out a file folder structure in the Hive in order to accommodate multiple partitions?) TIA, __Birm Ricardo Birmele, CISSP Senior Security Technologist Microsoft IT Security Operations • | | • [Microsoft Logo] From: Mohammad Tariq