/**
* Licensed to the Apache Software Foundation (ASF) under one
* or more contributor license agreements. See the NOTICE file
* distributed with this work for additional information
* regarding copyright ownership. The ASF licenses this file
* to you under the Apache License, Version 2.0 (the
* "License"); you may not use this file except in compliance
* with the License. You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
package com.alibaba.wasp.plan.parser.druid;
import com.alibaba.druid.sql.ast.SQLExpr;
import com.alibaba.druid.sql.ast.SQLStatement;
import com.alibaba.druid.sql.ast.statement.SQLSelect;
import com.alibaba.druid.sql.ast.statement.SQLSelectQuery;
import com.alibaba.druid.sql.ast.statement.SQLSelectQueryBlock;
import com.alibaba.druid.sql.ast.statement.SQLSelectStatement;
import com.alibaba.wasp.MetaException;
import com.alibaba.wasp.ZooKeeperConnectionException;
import com.alibaba.wasp.conf.WaspConfiguration;
import com.alibaba.wasp.meta.FMetaTestUtil;
import com.alibaba.wasp.meta.FTable;
import com.alibaba.wasp.meta.Index;
import com.alibaba.wasp.meta.MemFMetaStore;
import com.alibaba.wasp.meta.TableSchemaCacheReader;
import com.alibaba.wasp.plan.parser.ParseContext;
import com.alibaba.wasp.plan.parser.QueryInfo;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.apache.hadoop.conf.Configuration;
import org.junit.Assert;
import org.junit.Test;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;
public class TestFMetaEventOperation {
private static final Log LOG = LogFactory
.getLog(TestFMetaEventOperation.class);
private static ParseContext context = new ParseContext();
private Configuration conf = WaspConfiguration.create();
@Test
public void testCheckAndGetIndex() throws ZooKeeperConnectionException,
MetaException {
FTable table = FMetaTestUtil.getTestTable();
List<String> fields = new ArrayList<String>();
fields.add("c4");
fields.add("c5");
Index i1 = FMetaTestUtil.makeIndex(table, "i1", fields);
table.addIndex(i1);
fields = new ArrayList<String>();
fields.add("c5");
fields.add("c4");
Index i2 = FMetaTestUtil.makeIndex(table, "i2", fields);
table.addIndex(i2);
String sql1 = "SELECT c1, c2, c3 from test where c4=1 and c5=2;";
String sql2 = "SELECT c1, c2, c3 from test where c5=2 and c4=1;";
String[] sqlList = { sql1, sql2 }; // sql1, sql2, sql3
Index[] indexs = { i1, i2 }; // sql1, sql2, sql3
DruidDQLParser druidParser = new DruidDQLParser(conf);
for (int i = 0; i < sqlList.length; i++) {
String sql = sqlList[i];
context.setSql(sql);
try {
druidParser.parseSqlToStatement(context);
SQLStatement stmt = context.getStmt();
if (stmt instanceof SQLSelectStatement) {
MemFMetaStore fmetaServices = new MemFMetaStore();
TableSchemaCacheReader reader = TableSchemaCacheReader.getInstance(
conf, fmetaServices);
reader.addSchema(table.getTableName(), table);
MetaEventOperation metaEventOperation = new FMetaEventOperation(
reader);
SQLSelectStatement sqlSelectStatement = (SQLSelectStatement) stmt;
// this is SELECT clause
SQLSelect select = sqlSelectStatement.getSelect();
SQLSelectQuery sqlSelectQuery = select.getQuery();
if (sqlSelectQuery instanceof SQLSelectQueryBlock) {
SQLSelectQueryBlock sqlSelectQueryBlock = (SQLSelectQueryBlock) sqlSelectQuery;
// Parse The WHERE clause
SQLExpr where = sqlSelectQueryBlock.getWhere();
LOG.debug("SELECT SQL:where " + where);
QueryInfo queryInfo = druidParser.parseWhereClause(table,
metaEventOperation, where, false);
Index index = metaEventOperation.checkAndGetIndex(table,
queryInfo.getAllConditionFieldName());
// Get the right Index
Assert.assertEquals(indexs[i].getIndexName(), index.getIndexName());
}
}
Assert.assertTrue(true);
} catch (IOException ioe) {
LOG.error(ioe);
Assert.assertTrue(false);
} finally {
TableSchemaCacheReader.getInstance(conf, null);
}
} // for
}
}