-
You can use partition/subpartition names where ever you can use tables. For example - select * from table.partition_name or select * from table.partition_name.subpartition_name
Similarly, Truncate table.partition_name and Truncate table.partition_name.subpartition_name.
2009-09-18 04:47:41 UTC in CloudBase
-
In the next release (2.0), I have added support for partitioning in CloudBase. When you create a table, you can specify partition and sub partition clause-
CREATE TABLE tablename
( c1 int, c2 datetime, c3 varchar ...)
PARTITION BY RANGE | HASH | LIST
SUBPARTITION BY RANGE | HASH | LIST
The syntax is similar to MySql.
Although, what you have asked is different than partitioning, but...
2009-09-17 09:45:12 UTC in CloudBase
-
Thats a good point. Furhther, I was thinking of doing the insert into RDBS in parallel- once the mappers or reducers finished execution, directly push the data into RDBMS.
I guess a new output format- DBOutputFormat can be created for this. Hadoop already has something like that, but I have not seen the code yet. If that is suitable, we can use that else create a new class. In that class, we...
2009-09-17 09:34:18 UTC in CloudBase
-
"The data types that are accepted as function arguments and return types are- byte, short, int, long, float, double, java.lang.String and java.util.Date".
2009-06-25 05:23:25 UTC in CloudBase
