|
|||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | ||||||||
java.lang.Objectorg.openi.jdbc.impl.SqlProviderPostgreSQL
public class SqlProviderPostgreSQL
| Constructor Summary | |
|---|---|
SqlProviderPostgreSQL()
|
|
| Method Summary | |
|---|---|
java.lang.String |
generateFetchColumnDataSql(java.lang.String targetTable,
java.lang.String targetColumn,
int sampleSize)
if sampleSize >0, then fetch sample of data: select top 10 targetColumn from targetTable order by newid() if samplesize < 0, then just fetch all rows for column: select targetColumn from targetTable |
java.lang.String |
generateFetchMinMaxSql(java.lang.String targetTable,
java.lang.String targetColumn)
select min(targetColumn), max(targetColumn) from targetTable |
java.lang.String |
generateFetchRowCountSql(java.lang.String targetTable)
select count(*) from targetTable |
java.lang.String |
generateSegmentSql(java.util.List bucketList,
java.lang.String targetTable,
java.lang.String targetColumn)
Generates entire segment sql, in the case of microsoft sql server result looks like this: select count(warehouse_sales) as frequency, CASE WHEN warehouse_sales between 0.0 AND 56.0 THEN 0 WHEN warehouse_sales between 56.0 AND 112.0 THEN 1 WHEN warehouse_sales between 112.0 AND 168.0 THEN 2 WHEN warehouse_sales between 168.0 AND 224.0 THEN 3 ELSE -1 END AS warehouse_sales_bucket FROM [inventory_fact_1997] group by ( CASE WHEN warehouse_sales between 0.0 AND 56.0 THEN 0 WHEN warehouse_sales between 56.0 AND 112.0 THEN 1 WHEN warehouse_sales between 112.0 AND 168.0 THEN 2 WHEN warehouse_sales between 168.0 AND 224.0 THEN 3 ELSE -1 END ) |
| Methods inherited from class java.lang.Object |
|---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
| Constructor Detail |
|---|
public SqlProviderPostgreSQL()
| Method Detail |
|---|
public java.lang.String generateFetchMinMaxSql(java.lang.String targetTable,
java.lang.String targetColumn)
SqlProvider
generateFetchMinMaxSql in interface SqlProviderpublic java.lang.String generateFetchRowCountSql(java.lang.String targetTable)
SqlProvider
generateFetchRowCountSql in interface SqlProvider
public java.lang.String generateSegmentSql(java.util.List bucketList,
java.lang.String targetTable,
java.lang.String targetColumn)
SqlProvider
generateSegmentSql in interface SqlProvider
public java.lang.String generateFetchColumnDataSql(java.lang.String targetTable,
java.lang.String targetColumn,
int sampleSize)
SqlProvider
generateFetchColumnDataSql in interface SqlProvider
|
|||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | ||||||||