Greenplum Database 4.3 dynamically generates tables using the MyBatis framework

1. Use mabatis3 annotation form, do not use XML to configure SQL mode. Because data warehouses are mostly used for calculations, there are no complex query conditions

Mapper class annotations CREATE TABLE code:

Package Com.aicai.cepchassis.fastsampling.dao;import Org.apache.ibatis.annotations.param;import Org.apache.ibatis.annotations.update;public interface Httplogtabledao {@Update ("CREATE Table ${tablename} (  " + " ID serialnot NULL,  "+" \ "machineid\"  varchar (n), "+" \ "requestpath\"  varchar (n), "+" Referer  varchar (n),  "+" IP  varchar (n), "+" \ "useragent\" varchar (n),  "+" Vuid varchar (n), "+" \ "timelocal \ "Timestamp without time zone,  " + "message varchar" + "  with (Appendonly=true,  orientation=row)" + "Distributed by (ID)") void CreateTable (@Param ("TableName") String tableName);

The table name uses the underscore form to divide the word, does not use the Hump form.

The field name is in camel form. Therefore, the field needs to be added "" double quotation marks.

Table Name parameter annotations

@Param ("TableName")

, SQL uses

${tablename} string substitution form obtained.

Greenplum Database 4.3 dynamically generates tables using the MyBatis framework