When you use cloudbase, you can create different table for different
daily files.
For example, your directory will like this.
logs
/200905
/20090501.log.gz
/20090502.log.gz
/200906
/20090601.log.gz
/20090602.log.gz
You will create 7 tables, four for daily, two for month, one for all.
2009/6/20 Edisonxp <ediso...@gmail.com>:
> I've used cloudbase for several months,since version 1.1 .it's a good
> thing,your team did a great job.
> These days, I'm annoying with a problem:with the increasing of data,the my
> daily queries become more and more slow.i hope that cloudbase should have a
> 'partition' feature with the creation of table.I used to try 'index', but it
> seems nothing changed.
>
> 发自我的 iPhone
>
> 在 2009-6-20，3:19，Leo Dagum <leo_da...@yahoo.com> 写到：
>
>> CloudBase is a data warehouse system for Terabyte & Petabyte scale
>> analytics. It is built on top of hadoop. It allows you
>> to query flat files using ANSI SQL.
>>
>>
>> We have released 1.3.1 version of CloudBase on sourceforge-
>> https://sourceforge.net/projects/cloudbase
>>
>> Please give it a try and send us your feedback.
>>
>> You can follow CloudBase related discussion in the google mail list:
>>
>> cloudbase-us...@googlegroups.com
>>
>>
>>
>> Release notes -
>>
>> New Features:
>> * CREATE CSV tables - One can create tables on top of data in CSV
>> (Comma Separated Values) format and query them using SQL. Current
>> implementation doesn't accept CSV records which span multiple lines.
>> Data may not be processed correctly if a field contains embedded line-
>> breaks. Please visit http://cloudbase.sourceforge.net/index.html#userDoc
>> for detailed specification of the CSV format.
>>
>> Bug fixes:
>> * Aggregate function 'AVG' returns the same value as 'SUM' function
>> * If a query has multiple aliases, only the last alias works
>> --~--~---------~--~----~------------~-------~--~----~
>> You received this message because you are subscribed to the Google Groups
>> "CloudBase" group.
>> To post to this group, send email to cloudbase-us...@googlegroups.com
>> To unsubscribe from this group, send email to
>> cloudbase-users+unsubscr...@googlegroups.com
>> For more options, visit this group at
>> http://groups.google.com/group/cloudbase-users?hl=en
>> -~----------~----~----~----~------~----~------~--~---
>
