Beispiel #1
0
 private String getStorageStringWithAlias(
     CandidateFact fact, Map<Dimension, CandidateDim> dimsToQuery, String alias) {
   if (cubeTbls.get(alias) instanceof CubeInterface) {
     return fact.getStorageString(alias);
   } else {
     return dimsToQuery.get(cubeTbls.get(alias)).getStorageString(alias);
   }
 }
Beispiel #2
0
  private void getQLString(
      QBJoinTree joinTree,
      StringBuilder builder,
      CandidateFact fact,
      Map<Dimension, CandidateDim> dimsToQuery)
      throws LensException {
    List<String> joiningTables = new ArrayList<>();
    if (joinTree.getBaseSrc()[0] == null) {
      if (joinTree.getJoinSrc() != null) {
        getQLString(joinTree.getJoinSrc(), builder, fact, dimsToQuery);
      }
    } else { // (joinTree.getBaseSrc()[0] != null){
      String alias = joinTree.getBaseSrc()[0].toLowerCase();
      builder.append(getStorageStringWithAlias(fact, dimsToQuery, alias));
      joiningTables.add(alias);
    }
    if (joinTree.getJoinCond() != null) {
      builder.append(JoinUtils.getJoinTypeStr(joinTree.getJoinCond()[0].getJoinType()));
      builder.append(" JOIN ");
    }
    if (joinTree.getBaseSrc()[1] == null) {
      if (joinTree.getJoinSrc() != null) {
        getQLString(joinTree.getJoinSrc(), builder, fact, dimsToQuery);
      }
    } else { // (joinTree.getBaseSrc()[1] != null){
      String alias = joinTree.getBaseSrc()[1].toLowerCase();
      builder.append(getStorageStringWithAlias(fact, dimsToQuery, alias));
      joiningTables.add(alias);
    }

    String joinCond = joinConds.get(joinTree);
    if (joinCond != null) {
      builder.append(" ON ");
      builder.append(joinCond);
      // joining tables will contain all tables involved in joins.
      // we need to push storage filters for Dimensions into join conditions, thus the following
      // code
      // takes care of the same.
      for (String joiningTable : joiningTables) {
        if (cubeTbls.get(joiningTable) instanceof Dimension) {
          DimOnlyHQLContext.appendWhereClause(
              builder, getWhereClauseWithAlias(dimsToQuery, joiningTable), true);
          dimsToQuery.get(cubeTbls.get(joiningTable)).setWhereClauseAdded(joiningTable);
        }
      }
    } else {
      throw new LensException(LensCubeErrorCode.NO_JOIN_CONDITION_AVAILABLE.getLensErrorInfo());
    }
  }
Beispiel #3
0
 private void addOptionalDimTable(
     String alias,
     CandidateTable candidate,
     boolean isRequiredInJoin,
     String cubeCol,
     boolean isRef,
     String tableAlias,
     String... cols)
     throws LensException {
   alias = alias.toLowerCase();
   if (!addQueriedTable(alias, true)) {
     throw new LensException(LensCubeErrorCode.QUERIED_TABLE_NOT_FOUND.getLensErrorInfo(), alias);
   }
   Dimension dim = (Dimension) cubeTbls.get(alias);
   Aliased<Dimension> aliasedDim = Aliased.create(dim, alias);
   OptionalDimCtx optDim = optionalDimensionMap.get(aliasedDim);
   if (optDim == null) {
     optDim = new OptionalDimCtx();
     optionalDimensionMap.put(aliasedDim, optDim);
   }
   if (cols != null && candidate != null) {
     for (String col : cols) {
       optDim.colQueried.add(col);
     }
     optDim.requiredForCandidates.add(candidate);
   }
   if (cubeCol != null) {
     if (isRef) {
       updateRefColDim(cubeCol, aliasedDim);
     } else {
       updateExprColDim(tableAlias, cubeCol, aliasedDim);
     }
   }
   if (!optDim.isRequiredInJoinChain) {
     optDim.isRequiredInJoinChain = isRequiredInJoin;
   }
   if (log.isDebugEnabled()) {
     log.debug(
         "Adding optional dimension:{} optDim:{} {} isRef:{}",
         aliasedDim,
         optDim,
         (cubeCol == null ? "" : " for column:" + cubeCol),
         isRef);
   }
 }
Beispiel #4
0
 String getQBFromString(CandidateFact fact, Map<Dimension, CandidateDim> dimsToQuery)
     throws LensException {
   String fromString;
   if (getJoinAST() == null) {
     if (cube != null) {
       if (dimensions.size() > 0) {
         throw new LensException(LensCubeErrorCode.NO_JOIN_CONDITION_AVAILABLE.getLensErrorInfo());
       }
       fromString = fact.getStorageString(getAliasForTableName(cube.getName()));
     } else {
       if (dimensions.size() != 1) {
         throw new LensException(LensCubeErrorCode.NO_JOIN_CONDITION_AVAILABLE.getLensErrorInfo());
       }
       Dimension dim = dimensions.iterator().next();
       fromString = dimsToQuery.get(dim).getStorageString(getAliasForTableName(dim.getName()));
     }
   } else {
     StringBuilder builder = new StringBuilder();
     getQLString(qb.getQbJoinTree(), builder, fact, dimsToQuery);
     fromString = builder.toString();
   }
   return fromString;
 }
Beispiel #5
0
 private String getWhereClauseWithAlias(Map<Dimension, CandidateDim> dimsToQuery, String alias) {
   return StorageUtil.getWhereClause(dimsToQuery.get(cubeTbls.get(alias)), alias);
 }
Beispiel #6
0
 public AbstractCubeTable getCubeTableForAlias(String alias) {
   return cubeTbls.get(alias);
 }
Beispiel #7
0
 public String getAlias(String expr) {
   return exprToAlias.get(expr);
 }