org.teiid.metadata.Table.setCardinality()方法的使用及代码示例

x33g5p2x  于2022-01-30 转载在 其他  
字(11.4k)|赞(0)|评价(0)|浏览(244)

本文整理了Java中org.teiid.metadata.Table.setCardinality()方法的一些代码示例，展示了Table.setCardinality()的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台，是从一些精选项目中提取出来的代码，具有较强的参考意义，能在一定程度帮忙到你。Table.setCardinality()方法的具体详情如下：
包路径：org.teiid.metadata.Table
类名称：Table
方法名：setCardinality

Table.setCardinality介绍

暂无

代码示例

代码示例来源：origin: org.teiid.connectors/translator-jdbc

  1. @Override
  2. protected void getTableStatistics(Connection conn, String catalog, String schema, String name, Table table) throws SQLException {
  3.   PreparedStatement stmt = null;
  4.   ResultSet rs = null;
  5.   try {
  6.     stmt = conn.prepareStatement("select num_rows from ALL_TABLES where owner = ? AND table_name = ?");  //$NON-NLS-1$
  7.     stmt.setString(1, schema);
  8.     stmt.setString(2, name);
  9.     rs = stmt.executeQuery();
  10.     if(rs.next()) {
  11.       int cardinality = rs.getInt(1);
  12.       if (!rs.wasNull()) {
  13.         table.setCardinality(cardinality);
  14.       }
  15.     }
  16.   } finally { 
  17.     if(rs != null) {
  18.       rs.close();
  19.     }
  20.     if(stmt != null) {
  21.       stmt.close();
  22.     }
  23.   }
  24. }

代码示例来源：origin: teiid/teiid

  1. public void setTableStats(TableStats stats) {
  2.   if (stats.getCardinality() != null) {
  3.     setCardinality(stats.getCardinality().longValue());
  4.   }
  5. }

代码示例来源：origin: org.teiid.connectors/translator-jdbc

  1. @Override
  2. protected void getTableStatistics(Connection conn, String catalog, String schema, String name, Table table) throws SQLException {
  3.   PreparedStatement stmt = null;
  4.   ResultSet rs = null;
  5.   try {
  6.     stmt = conn.prepareStatement("SELECT cardinality FROM INFORMATION_SCHEMA.STATISTICS WHERE table_schema = ? AND table_name = ?");  //$NON-NLS-1$
  7.     if (catalog != null && schema == null) {
  8.       //mysql jdbc reports the schema as the catalog
  9.       stmt.setString(1, catalog);
  10.     } else {
  11.       stmt.setString(1, schema);
  12.     }
  13.     stmt.setString(2, name);
  14.     rs = stmt.executeQuery();
  15.     if(rs.next()) {
  16.       int cardinality = rs.getInt(1);
  17.       if (!rs.wasNull()) {
  18.         table.setCardinality(cardinality);
  19.       }
  20.     }
  21.   } finally { 
  22.     if(rs != null) {
  23.       rs.close();
  24.     }
  25.     if(stmt != null) {
  26.       stmt.close();
  27.     }
  28.   }
  29. }

代码示例来源：origin: teiid/teiid

  1. public static void setCardinality(String group, int cardinality, QueryMetadataInterface metadata) throws QueryMetadataException, TeiidComponentException {
  2.   if (metadata instanceof TransformationMetadata) {
  3.     Table t = (Table)metadata.getGroupID(group);
  4.     t.setCardinality(cardinality);
  5.   } else {
  6.     throw new RuntimeException("unknown metadata"); //$NON-NLS-1$
  7.   }
  8. }

代码示例来源：origin: teiid/teiid

  1. private static void removeTableOption(String key, Table table) {
  2.   if (table.getProperty(key, false) != null) {
  3.     table.setProperty(key, null);
  4.   }
  5.   removeCommonProperty(key, table);
  6.   
  7.   if (key.equals(DDLConstants.MATERIALIZED)) {
  8.     table.setMaterialized(false);
  9.   }
  10.   
  11.   if (key.equals(DDLConstants.MATERIALIZED_TABLE)) {
  12.     table.setMaterializedTable(null);
  13.   }
  14.   
  15.   if (key.equals(DDLConstants.UPDATABLE)) {
  16.     table.setSupportsUpdate(false);
  17.   }
  18.   
  19.   if (key.equals(DDLConstants.CARDINALITY)) {
  20.     table.setCardinality(-1);
  21.   }       
  22. }

代码示例来源：origin: org.jboss.teiid/teiid-engine

  1. private static void removeTableOption(String key, Table table) {
  2.   if (table.getProperty(key, false) != null) {
  3.     table.setProperty(key, null);
  4.   }
  5.   removeCommonProperty(key, table);
  6.   
  7.   if (key.equals(DDLConstants.MATERIALIZED)) {
  8.     table.setMaterialized(false);
  9.   }
  10.   
  11.   if (key.equals(DDLConstants.MATERIALIZED_TABLE)) {
  12.     table.setMaterializedTable(null);
  13.   }
  14.   
  15.   if (key.equals(DDLConstants.UPDATABLE)) {
  16.     table.setSupportsUpdate(false);
  17.   }
  18.   
  19.   if (key.equals(DDLConstants.CARDINALITY)) {
  20.     table.setCardinality(-1);
  21.   }       
  22. }

代码示例来源：origin: org.teiid/teiid-engine

  1. private static void removeTableOption(String key, Table table) {
  2.   if (table.getProperty(key, false) != null) {
  3.     table.setProperty(key, null);
  4.   }
  5.   removeCommonProperty(key, table);
  6.   
  7.   if (key.equals(DDLConstants.MATERIALIZED)) {
  8.     table.setMaterialized(false);
  9.   }
  10.   
  11.   if (key.equals(DDLConstants.MATERIALIZED_TABLE)) {
  12.     table.setMaterializedTable(null);
  13.   }
  14.   
  15.   if (key.equals(DDLConstants.UPDATABLE)) {
  16.     table.setSupportsUpdate(false);
  17.   }
  18.   
  19.   if (key.equals(DDLConstants.CARDINALITY)) {
  20.     table.setCardinality(-1);
  21.   }       
  22. }

代码示例来源：origin: org.jboss.teiid/teiid-engine

  1. private static void setTableOptions(Table table) {
  2.   Map<String, String> props = table.getProperties();
  3.   setCommonProperties(table, props);
  4.   
  5.   String value = props.remove(DDLConstants.MATERIALIZED); 
  6.   if (value != null) {
  7.     table.setMaterialized(isTrue(value));
  8.   }
  9.   
  10.   value = props.remove(DDLConstants.MATERIALIZED_TABLE); 
  11.   if (value != null) {
  12.     Table mattable = new Table();
  13.     mattable.setName(value);
  14.     table.setMaterializedTable(mattable);
  15.   }
  16.   
  17.   value = props.remove(DDLConstants.UPDATABLE); 
  18.   if (value != null) {
  19.     table.setSupportsUpdate(isTrue(value));
  20.   }
  21.   
  22.   value = props.remove(DDLConstants.CARDINALITY); 
  23.   if (value != null) {
  24.     table.setCardinality(Long.valueOf(value));
  25.   }
  26. }

代码示例来源：origin: org.teiid/teiid-engine

  1. private static void setTableOptions(Table table) {
  2.   Map<String, String> props = table.getProperties();
  3.   setCommonProperties(table, props);
  4.   
  5.   String value = props.remove(DDLConstants.MATERIALIZED); 
  6.   if (value != null) {
  7.     table.setMaterialized(isTrue(value));
  8.   }
  9.   
  10.   value = props.remove(DDLConstants.MATERIALIZED_TABLE); 
  11.   if (value != null) {
  12.     Table mattable = new Table();
  13.     mattable.setName(value);
  14.     table.setMaterializedTable(mattable);
  15.   }
  16.   
  17.   value = props.remove(DDLConstants.UPDATABLE); 
  18.   if (value != null) {
  19.     table.setSupportsUpdate(isTrue(value));
  20.   }
  21.   
  22.   value = props.remove(DDLConstants.CARDINALITY); 
  23.   if (value != null) {
  24.     table.setCardinality(Long.valueOf(value));
  25.   }
  26. }

代码示例来源：origin: teiid/teiid

  1. private static void setTableOptions(Table table) {
  2.   Map<String, String> props = table.getProperties();
  3.   setCommonProperties(table, props);
  4.   
  5.   String value = props.remove(DDLConstants.MATERIALIZED); 
  6.   if (value != null) {
  7.     table.setMaterialized(isTrue(value));
  8.   }
  9.   
  10.   value = props.remove(DDLConstants.MATERIALIZED_TABLE); 
  11.   if (value != null) {
  12.     Table mattable = new Table();
  13.     mattable.setName(value);
  14.     table.setMaterializedTable(mattable);
  15.   }
  16.   
  17.   value = props.remove(DDLConstants.UPDATABLE); 
  18.   if (value != null) {
  19.     table.setSupportsUpdate(isTrue(value));
  20.   }
  21.   
  22.   value = props.remove(DDLConstants.CARDINALITY); 
  23.   if (value != null) {
  24.     table.setCardinality(Long.valueOf(value));
  25.   }
  26. }

代码示例来源：origin: org.teiid.connectors/translator-jdbc

  1. short type = indexInfo.getShort(7);
  2. if (type == DatabaseMetaData.tableIndexStatistic) {
  3.   tableInfo.table.setCardinality(getCardinality(indexInfo));
  4.   cardinalitySet = true;
  5.   continue;
  6. if (useAnyIndexCardinality && !cardinalitySet) {
  7.   long cardinality = getCardinality(indexInfo);
  8.   tableInfo.table.setCardinality(Math.max(cardinality, (long)tableInfo.table.getCardinalityAsFloat()));

代码示例来源：origin: teiid/teiid

  1. cardinality = -1;
  2. table.setCardinality(cardinality);

代码示例来源：origin: org.teiid/teiid-metadata

  1. cardinality = -1;
  2. table.setCardinality(cardinality);

代码示例来源：origin: teiid/teiid

  1. public static void addAggregateTablesToModel(String modelName, MetadataStore metadataStore) {
  2.   // Create db2 tables
  3.   Schema model = createPhysicalModel(modelName, metadataStore); 
  4.   
  5.   Table orders = createPhysicalGroup("order", model); //$NON-NLS-1$
  6.   orders.setCardinality(1000000);
  7.   createElements(orders, 
  8.     new String[] { "O_OrderID", "O_ProductID", "O_DealerID", "O_Amount", "O_Date"}, //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$ //$NON-NLS-4$ //$NON-NLS-5$ 
  9.     new String[] { DataTypeManager.DefaultDataTypes.INTEGER, DataTypeManager.DefaultDataTypes.INTEGER, DataTypeManager.DefaultDataTypes.INTEGER, DataTypeManager.DefaultDataTypes.BIG_DECIMAL, DataTypeManager.DefaultDataTypes.DATE });
  11.   Table products = createPhysicalGroup("product", model); //$NON-NLS-1$
  12.   products.setCardinality(1000);
  13.   createElements(products, 
  14.     new String[] { "P_ProductID", "P_Overhead", "P_DivID"}, //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$ 
  15.     new String[] { DataTypeManager.DefaultDataTypes.INTEGER, DataTypeManager.DefaultDataTypes.BIG_DECIMAL, DataTypeManager.DefaultDataTypes.INTEGER});
  17.   Table divisions = createPhysicalGroup("division", model); //$NON-NLS-1$
  18.   divisions.setCardinality(100);
  19.   createElements(divisions, 
  20.     new String[] { "V_DIVID", "V_SectorID"}, //$NON-NLS-1$ //$NON-NLS-2$ 
  21.     new String[] { DataTypeManager.DefaultDataTypes.INTEGER, DataTypeManager.DefaultDataTypes.INTEGER});
  23.   Table dealers = createPhysicalGroup("dealer", model); //$NON-NLS-1$
  24.   dealers.setCardinality(1000);
  25.   createElements(dealers, 
  26.     new String[] { "D_DealerID", "D_State", "D_Address"}, //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$ 
  27.     new String[] { DataTypeManager.DefaultDataTypes.INTEGER, DataTypeManager.DefaultDataTypes.STRING, DataTypeManager.DefaultDataTypes.STRING});
  28. }

代码示例来源：origin: org.teiid.connectors/translator-salesforce

  1. Long val = this.connection.getCardinality(table.getNameInSource());
  2. if (val != null) {
  3.   table.setCardinality(val);

代码示例来源：origin: teiid/teiid

  1. @Test public void testCardinality() {
  2.   Table t = new Table();
  3.   assertEquals(-1, t.getCardinalityAsFloat(), 0);
  4.   t.setCardinality(1000);
  5.   assertEquals(1000, t.getCardinalityAsFloat(), 0);
  6.   t.setCardinality(100000111000111100l);
  7.   assertEquals(100000111000111100l/t.getCardinalityAsFloat(), 1, .01);
  8. }

代码示例来源：origin: teiid/teiid

  1. Table pm4g2 = createPhysicalGroup("g2", pm4); //$NON-NLS-1$
  2. pm1g1.setCardinality(10);
  3. pm1g2.setCardinality(10);
  4. pm1g3.setCardinality(10);
  5. pm2g1.setCardinality(1000);
  6. pm2g2.setCardinality(1000);
  7. pm3g1.setCardinality(100000);
  8. pm3g2.setCardinality(100000);
  9. pm3g3.setCardinality(100000);

代码示例来源：origin: teiid/teiid

  1. salesTable.setCardinality(1000000);
  2. createElements(salesTable, 
  3.   new String[] { "CITY", "MONTH", "SALES"}, //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$ 
  4. geographyTable2.setCardinality(1000);
  5. List<Column> geographyElem2 = createElements(geographyTable2, 
  6.   new String[] { "CITY", "REGION"}, //$NON-NLS-1$ //$NON-NLS-2$ 
  7. geographyTable.setCardinality(1000);
  8. List<Column> geographyElem = createElements(geographyTable, 
  9.   new String[] { "CITY", "REGION"}, //$NON-NLS-1$ //$NON-NLS-2$ 
  10. timeTable.setCardinality(120);
  11. List<Column> timeElem = createElements(timeTable, 
  12.   new String[] { "MONTH", "YEAR"}, //$NON-NLS-1$ //$NON-NLS-2$

代码示例来源：origin: teiid/teiid

  1. Schema us = RealMetadataFactory.createPhysicalModel("US", metadataStore); //$NON-NLS-1$
  2. Table usAccts = RealMetadataFactory.createPhysicalGroup("Accounts", us); //$NON-NLS-1$
  3. usAccts.setCardinality(1000000);
  4. List<Column> usAcctsElem = RealMetadataFactory.createElements(usAccts, 
  5.               new String[] { "customer", "account", "txn", "txnid", "pennies" }, //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$ //$NON-NLS-4$ //$NON-NLS-5$
  6. euAccts.setCardinality(1000000);
  7. List<Column> euAcctsElem = RealMetadataFactory.createElements(euAccts, 
  8.               new String[] { "id", "accid", "type", "amount" }, //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$ //$NON-NLS-4$
  9. customers.setCardinality(1000);
  10. List<Column> customersElem = RealMetadataFactory.createElements(customers, 
  11.               new String[] { "id", "first", "last", "birthday" }, //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$ //$NON-NLS-4$
  12. locations.setCardinality(1200);
  13. List<Column> locationsElem = RealMetadataFactory.createElements(locations, 
  14.               new String[] { "id", "location" }, //$NON-NLS-1$ //$NON-NLS-2$

代码示例来源：origin: teiid/teiid

  1. @Test public void testForeignTemp() {
  2.   Create create = new Create();
  3.   create.setTable(new GroupSymbol("tempTable")); //$NON-NLS-1$
  4.   create.setOn("source");
  5.   Table t = new Table();
  6.   t.setName("tempTable");
  7.   t.setUUID("tid:0");
  8.   Column c = new Column();
  9.   c.setName("x");
  10.   c.setUUID("tid:0");
  11.   Datatype string = SystemMetadata.getInstance().getRuntimeTypeMap().get("string");
  12.   c.setDatatype(string, true, 0);
  13.   t.addColumn(c);
  14.   c = new Column();
  15.   c.setName("y");
  16.   c.setUUID("tid:0");
  17.   Datatype decimal = SystemMetadata.getInstance().getRuntimeTypeMap().get("decimal");
  18.   c.setDatatype(decimal, true, 0);
  19.   t.addColumn(c);
  20.   t.setCardinality(10000);
  21.   create.setTableMetadata(t);
  22.   helpTest("create foreign temporary table tempTable (x string, y decimal) options (cardinality 10000) on source", "CREATE FOREIGN TEMPORARY TABLE tempTable (\n	x string,\n	y bigdecimal\n) OPTIONS (CARDINALITY 10000) ON 'source'", create); //$NON-NLS-1$ //$NON-NLS-2$
  23. }

内容来源于网络，如有侵权，请联系作者删除！

Table

相关文章

    查看更多

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新文章

    更多

    Table类方法

    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com