Help with last 30 day unique user query

Hi, I need help with this scenario. We have a table of events which has columns date, event (not important for this discussion), and user_id. It is obviously easy to find number of unique users for each day. I also need to find number of unique users in the last 30 days for each day. This is also q

Re: when is hive0.6 released

ok, thank you very much. 2010/10/15 Carl Steinbach > Hi, > > HIVE-1681 does not require any changes to the database schema. It is > strictly > a code change. > > Carl > > > On Thu, Oct 14, 2010 at 11:19 PM, lei liu wrote: > >> Hi Carl Steinbach, >> >> Could you tell me this issues will result i

Re: when is hive0.6 released

Hi, HIVE-1681 does not require any changes to the database schema. It is strictly a code change. Carl On Thu, Oct 14, 2010 at 11:19 PM, lei liu wrote: > Hi Carl Steinbach, > > Could you tell me this issues will result in the database structure is > changed? > > > 2010/10/15 Carl Steinbach > >

Re: when is hive0.6 released

Hi Carl Steinbach, Could you tell me this issues will result in the database structure is changed? 2010/10/15 Carl Steinbach > Hi LiuLei, > > We plan to make one more change to the metastore code (HIVE-1681) before > building the 0.6 release. I expect that the patch for HIVE-1681 will get > com

Re: when is hive0.6 released

Hi LiuLei, We plan to make one more change to the metastore code (HIVE-1681) before building the 0.6 release. I expect that the patch for HIVE-1681 will get committed to trunk and the 0.6 branch sometime in the next couple of days. You can track progress on the list of unresolved 0.6 blockers on t

seattle hadoop announce: meeting October 21st @ 7:15 pm, Cascading and Hive

Hello Fellow Hadoopists, We are meeting at 7:15 pm on October 21st at the University Heights Community Center 5031 University Way NE Seattle WA 98105 Room #110 The meetings are informal and highly conversational. If you have questions about Hadoop and map reduce this is a great place to ask the

Re: when is hive0.6 released

Hi Carl Steinbach , Thank you for your reply quickly. I look the metastore code is updated in 06/Oct/10 (please see HIVE-1364 issues), could you tell me whether the metasote code in svn will not be updated again when hive0.6 is released? Thanks,

Re: when is hive0.6 released

Hi, We're working on building the first release candidate for 0.6. I expect that the official release will happen soon, but I can't promise that it will occur it in the next week. Thanks. Carl On Thu, Oct 14, 2010 at 7:30 PM, lei liu wrote: > This month our system will be released, so I want

when is hive0.6 released

This month our system will be released, so I want to use newest hive0.6 version, I want to know hive0.6 whether can be released in next week. Thanks, LiuLei

When I close the connection, hive don't clean hive.exec.scratchdir directory

I use JDBC to connection hive server, I find when I close connection, hive don't clean hive.exec.scratchdir directory, so after hive run long time, the hive.exec.scratchdir directory include a lot of files. Now we use timer to clean the directory, but I think hive should add one plugin for closin

Got question after deploy hadoop-0.21.0

Hi, I got some question after deploy hadoop-0.21.0 need to help. There is a new deploy not update, and i execute start-hdfs.sh, start-mapred.sh, got the message in the log file below: 2010-10-14 16:59:55,354 INFO org.apache.hadoop.ipc.Server: IPC Server listener on 9000: readAndProcess threw exce