Examples of org.voltdb.planner.PlanColumn

org.voltdb.planner.PlanColumn
A PlanColumn organizes all of the schema and meta-data about a column that is required by the planner. Each plan node has an output column list of PlanColumns specifying its output schema. Column value types are stored in the column's associated expression. Once the AST objects generated from the parsed HSQL are processed into plan nodes, all column references should be managed as PlanColumn GUIDs. Eventually, AbstractExpressions should reference column GUIDs allowing walking the expression should lead to the GUIDs for the expression input columns - those inputs are sometimes referred to as origin columns in comments and variable names.

            PlanColumn.Storage storage = PlanColumn.Storage.kPartitioned;
            if (db.getTables().getIgnoreCase(m_targetTableName).getIsreplicated())
                storage = PlanColumn.Storage.kReplicated;


            // construct the columns and store them in index-ordering
            PlanColumn orderedCols[] = new PlanColumn[cols.size()];


            // you don't strictly need to sort this, but it makes diff-ing easier
            for (Column col : CatalogUtil.getSortedCatalogItems(cols, "index")) {
                // must produce a tuple value expression for this column.
                TupleValueExpression tve = new TupleValueExpression();

View Full Code Here

    public PlanColumn findMatchingOutputColumn(String tableName,
                                               String columnName,
                                               String columnAlias)
    {
        boolean found = false;
        PlanColumn retval = null;
        for (Integer colguid : m_outputColumns) {
            PlanColumn plancol = m_context.get(colguid);
            if ((plancol.originTableName().equals(tableName)) &&
                ((plancol.originColumnName().equals(columnName)) ||
                 (plancol.originColumnName().equals(columnAlias))))
            {
                found = true;
                retval = plancol;
                break;
            }

View Full Code Here

        stringer.endArray(); //end inlineNodes


        stringer.key(Members.OUTPUT_COLUMNS.name());
        stringer.array();
        for (int col = 0; col < m_outputColumns.size(); col++) {
            PlanColumn column = m_context.get(m_outputColumns.get(col));
            column.toJSONString(stringer);
        }
        stringer.endArray();
    }

View Full Code Here

        }
        
        JSONArray outputColumns = obj.getJSONArray(Members.OUTPUT_COLUMNS.name());
        for (int ii = 0; ii < outputColumns.length(); ii++) {
            JSONObject jsonObject = outputColumns.getJSONObject(ii);
            PlanColumn column = PlanColumn.fromJSONObject(jsonObject, db);
            assert(column != null);
            node.m_outputColumns.add(column.guid());
//            System.err.println(String.format("[%02d] %s => %s", ii, node, column));
        }
        
        node.loadFromJSONObject(obj, db);

View Full Code Here


        if (!m_groupByColumnGuids.isEmpty())
        {   
            stringer.key(Members.GROUPBY_COLUMNS.name()).array();
            for (int i = 0; i < m_groupByColumnGuids.size(); i++) {
                PlanColumn column = m_context.get(m_groupByColumnGuids.get(i));
                column.toJSONString(stringer);
            }
            stringer.endArray();
        }
    }

View Full Code Here

        
        try {
            JSONArray groupbyColumnGuids = obj.getJSONArray(Members.GROUPBY_COLUMNS.name());
            for (int ii = 0; ii < groupbyColumnGuids.length(); ii++) {
                JSONObject jsonObject = groupbyColumnGuids.getJSONObject(ii);
                PlanColumn column = PlanColumn.fromJSONObject(jsonObject, db);
                m_groupByColumnGuids.add(column.guid());
            }
        } catch (JSONException e) {
            //okay not to be there.
        }
    }

View Full Code Here

    public void validate() throws Exception {
        super.validate();


        // Validate Expression Trees
        for (int ctr = 0; ctr < m_outputColumns.size(); ctr++) {
            PlanColumn column = m_context.get(m_outputColumns.get(ctr));
            AbstractExpression exp = column.getExpression();
            if (exp == null) {
                throw new Exception("ERROR: The Output Column Expression at position '" + ctr + "' is NULL");
            }
            exp.validate();
        }

View Full Code Here

            // PROJECTION
            // ---------------------------------------------------
            case MATERIALIZE:
            case PROJECTION: {
                for (Integer col_guid : node.getOutputColumnGUIDs()) {
                    PlanColumn col = plannerContext.get(col_guid);
                    assert (col != null) : "Invalid PlanColumn #" + col_guid;
                    if (col.getExpression() != null)
                        exps.add(col.getExpression());
                } // FOR
                break;
            }
            // ---------------------------------------------------
            // AGGREGATE
            // ---------------------------------------------------
            case AGGREGATE:
            case HASHAGGREGATE: {
                AggregatePlanNode agg_node = (AggregatePlanNode) node;
                for (Integer col_guid : agg_node.getAggregateColumnGuids()) {
                    PlanColumn col = plannerContext.get(col_guid);
                    assert (col != null) : "Invalid PlanColumn #" + col_guid;
                    if (col.getExpression() != null)
                        exps.add(col.getExpression());
                } // FOR
                for (Integer col_guid : agg_node.getGroupByColumnGuids()) {
                    PlanColumn col = plannerContext.get(col_guid);
                    assert (col != null) : "Invalid PlanColumn #" + col_guid;
                    if (col.getExpression() != null)
                        exps.add(col.getExpression());
                } // FOR
                break;
            }
            // ---------------------------------------------------
            // ORDERBY
            // ---------------------------------------------------
            case ORDERBY: {
                OrderByPlanNode orby_node = (OrderByPlanNode) node;
                for (Integer col_guid : orby_node.getSortColumnGuids()) {
                    PlanColumn col = plannerContext.get(col_guid);
                    assert (col != null) : "Invalid PlanColumn #" + col_guid;
                    if (col.getExpression() != null)
                        exps.add(col.getExpression());
                } // FOR
                break;
            }
            default:
                // Do nothing...

View Full Code Here

        final PlannerContext pcontext = PlannerContext.singleton();
        final Collection<Integer> planColumnIds = getOutputColumnIdsForPlanNode(node);


        final Set<Column> columns = new ListOrderedSet<Column>();
        for (Integer column_guid : planColumnIds) {
            PlanColumn planColumn = pcontext.get(column_guid);
            assert (planColumn != null);
            AbstractExpression exp = planColumn.getExpression();
            assert (exp != null);
            Collection<Column> exp_cols = ExpressionUtil.getReferencedColumns(catalog_db, exp);
            if (debug.val)
                LOG.debug(planColumn.toString() + " => " + exp_cols);
            columns.addAll(exp_cols);
        } // FOR


        return (columns);
    }

View Full Code Here

        final PlannerContext pcontext = PlannerContext.singleton();
        final Collection<Integer> planColumnIds = getOutputColumnIdsForPlanNode(node);


        final Collection<AbstractExpression> exps = new ListOrderedSet<AbstractExpression>();
        for (Integer column_guid : planColumnIds) {
            PlanColumn planColumn = pcontext.get(column_guid);
            assert (planColumn != null);
            AbstractExpression exp = planColumn.getExpression();
            assert (exp != null);
            exps.add(exp);
        } // FOR


        return (exps);

View Full Code Here

0 1 2 3 4

TOP

Related Classes of org.voltdb.planner.PlanColumn

edu.brown.catalog.CatalogUtil

edu.brown.optimizer.BasePlanOptimizerTestCase

edu.brown.optimizer.optimizations.AggregatePushdownOptimization

edu.brown.optimizer.optimizations.ProjectionPushdownOptimization

edu.brown.optimizer.optimizations.RemoveRedundantProjectionsOptimizations

edu.brown.optimizer.PlanOptimizerUtil

edu.brown.optimizer.TestPlanOptimizer

edu.brown.optimizer.TestPlanOptimizerTPCC

edu.brown.plannodes.PlanNodeUtil

org.json.JSONObject

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.