Re: Hive - Issue Converting Text to Orc

Prasanth, I am also traveling this week. Your assistance would be appreciated, but not at the expense of your holiday! Bryan On Dec 24, 2013 2:23 PM, "Prasanth Jayachandran" < pjayachand...@hortonworks.com> wrote: > Bryan > > I have a similar setup. I will try to reproduce this issue and get ba

Re: Hive - Issue Converting Text to Orc

Bryan I have a similar setup. I will try to reproduce this issue and get back to you asap. Since i am traveling expect some delay. Thanks Prasanth Sent from my iPhone > On Dec 24, 2013, at 11:39 AM, Bryan Jeffrey wrote: > > Hello. > > I posted this a few weeks ago, but was unable to g

Re: Hive - Issue Converting Text to Orc

Hello. I posted this a few weeks ago, but was unable to get a response that solved the issue. I have made no headway in the mean time. I was hoping that if I re-summarized the issue that someone would have some advice regarding this problem. Running the following version of Hadoop: hadoop-2.2.0

CASE Statement not working in hive

Hello all, I have wrote this query . *" select* *case when as_date rlike '2013-05-01' then as_date else '2013-07-04' end as as_date from table AA ; " * as the value of as_date i.e 2013-05-01 exists in table AA it *should return the value 2013-05-01 *(Which is true in case statement) but

Re: to find the 1st day of the month in hive

Hi, Can i use this. select date_sub('2013-12-08', (day('2013-12-08')) -1) from table. just want to cross chk On Tue, Dec 24, 2013 at 3:48 PM, yogesh dhari wrote: > Hello, > > I have a use case where I need to find the 1st day of the month of > entered date. > > > > like if the date is 20

Re: Date format in Hive

you can use python rather than java. its simpler to learn and easier to write On Tue, Dec 24, 2013 at 2:08 PM, yogesh dhari wrote: > Java nahi aati, to udf kaha se likhu.. > > koi hive ka function hi bata ya work around it.. > > ya fir shell script me kaisey kerney ka h ... > > > On Tue, Dec 24

to find the 1st day of the month in hive

Hello, I have a use case where I need to find the 1st day of the month of entered date. like if the date is 2013-12-05 i need to get 2013-12-01. how to do it in Hive. (wont preffer to use UDF, like by doing some date_sub kind of or other function) Pls suggest Thanks Yogesh

Python Udfs

Hi, Has anyone written a python udf that can take the input as the group by of a subquery and process this set to output something. If yes can you please share a query that uses this udf ? -- Sreenath S Kamath Bangalore Ph No:+91-9590989106

Re: STREAMTABLE And MAPJOIN

This seems useful, so I added a sentence to the explanation of STREAMTABLE in the JOINS wikidoc : >- > >In every map/reduce stage of the join, the table to be streamed can be >specifie

Re: Date format in Hive

Java nahi aati, to udf kaha se likhu.. koi hive ka function hi bata ya work around it.. ya fir shell script me kaisey kerney ka h ... On Tue, Dec 24, 2013 at 12:47 PM, wrote: > Hello Dhari, > > Write a hive udf, > 1.which ll take date as argument. > 2.extract yr, mon,date from string, create