query.setOrdering("functionName ascending"); Collection names = (Collection) query.executeWithArray(parameterVals.toArray(new String[parameterVals.size()])); funcs = new ArrayList<>();
@Override public List<String> getDatabases(String catName, String pattern) throws MetaException { if (pattern == null || pattern.equals("*")) { return getAllDatabases(catName); } boolean commited = false; List<String> databases = null; Query query = null; try { openTransaction(); // Take the pattern and split it on the | to get all the composing // patterns String[] subpatterns = pattern.trim().split("\\|"); StringBuilder filterBuilder = new StringBuilder(); List<String> parameterVals = new ArrayList<>(subpatterns.length); appendSimpleCondition(filterBuilder, "catalogName", new String[] {catName}, parameterVals); appendPatternCondition(filterBuilder, "name", subpatterns, parameterVals); query = pm.newQuery(MDatabase.class, filterBuilder.toString()); query.setResult("name"); query.setOrdering("name ascending"); Collection<String> names = (Collection<String>) query.executeWithArray(parameterVals.toArray(new String[0])); databases = new ArrayList<>(names); commited = commitTransaction(); } finally { rollbackAndCleanup(commited, query); } return databases; }
query.declareParameters(parameterDeclaration); if (ascending) { query.setOrdering("partitionName ascending"); } else { query.setOrdering("partitionName descending");
private List<RuntimeStat> getMRuntimeStats(int maxEntries, int maxCreateTime) { Query<MRuntimeStat> query = pm.newQuery(MRuntimeStat.class); query.setOrdering("createTime descending"); if (maxCreateTime > 0) { query.setFilter("createTime < "+maxCreateTime); } if (maxEntries < 0) { maxEntries = Integer.MAX_VALUE; } List<RuntimeStat> ret = new ArrayList<>(); List<MRuntimeStat> res = (List<MRuntimeStat>) query.execute(); int totalEntries = 0; for (MRuntimeStat mRuntimeStat : res) { pm.retrieve(mRuntimeStat); totalEntries += mRuntimeStat.getWeight(); ret.add(MRuntimeStat.toThrift(mRuntimeStat)); if (totalEntries >= maxEntries) { break; } } return ret; }
query.setOrdering("eventId ascending"); int maxEventResponse = MetastoreConf.getIntVar(conf, ConfVars.METASTORE_MAX_EVENT_RESPONSE); int maxEvents = (rqst.getMaxEvents() < maxEventResponse && rqst.getMaxEvents() > 0) ? rqst.getMaxEvents() : maxEventResponse;
String parameterDeclaration = makeParameterDeclarationStringObj(params); query.declareParameters(parameterDeclaration); query.setOrdering("partitionName ascending"); if (fieldNames == null || fieldNames.isEmpty()) {
query.setOrdering("database,table ascending"); List<MTxnWriteNotificationLog> mplans = (List<MTxnWriteNotificationLog>)query.executeWithArray( parameterVals.toArray(new String[parameterVals.size()]));
query.setOrdering("tableName ascending"); Collection<String> names = (Collection<String>) query.executeWithArray(parameterVals.toArray(new String[0])); tbls = new ArrayList<>(names);
/** * Gets partition names from the table via ORM (JDOQL) name filter. * @param dbName Database name. * @param tblName Table name. * @param partNames Partition names to get the objects for. * @return Resulting partitions. */ private List<Partition> getPartitionsViaOrmFilter(String catName, String dbName, String tblName, List<String> partNames) throws MetaException { if (partNames.isEmpty()) { return new ArrayList<>(); } ObjectPair<Query, Map<String, String>> queryWithParams = getPartQueryWithParams(catName, dbName, tblName, partNames); Query query = queryWithParams.getFirst(); query.setResultClass(MPartition.class); query.setClass(MPartition.class); query.setOrdering("partitionName ascending"); @SuppressWarnings("unchecked") List<MPartition> mparts = (List<MPartition>)query.executeWithMap(queryWithParams.getSecond()); List<Partition> partitions = convertToParts(catName, dbName, tblName, mparts); if (query != null) { query.closeAll(); } return partitions; }
private List<MPartition> listMPartitions(String catName, String dbName, String tableName, int max, QueryWrapper queryWrapper) { boolean success = false; List<MPartition> mparts = null; try { openTransaction(); LOG.debug("Executing listMPartitions"); dbName = normalizeIdentifier(dbName); tableName = normalizeIdentifier(tableName); Query query = queryWrapper.query = pm.newQuery(MPartition.class, "table.tableName == t1 && table.database.name == t2 && table.database.catalogName == t3"); query.declareParameters("java.lang.String t1, java.lang.String t2, java.lang.String t3"); query.setOrdering("partitionName ascending"); if (max >= 0) { query.setRange(0, max); } mparts = (List<MPartition>) query.execute(tableName, dbName, catName); LOG.debug("Done executing query for listMPartitions"); pm.retrieveAll(mparts); success = commitTransaction(); LOG.debug("Done retrieving all objects for listMPartitions {}", mparts); } finally { if (!success) { rollbackTransaction(); } } return mparts; }
query.setOrdering("partitionName ascending"); @SuppressWarnings("unchecked") List<MPartition> mparts = (List<MPartition>) query.executeWithMap(params);
query.setFilter(filter); query.declareParameters(paramStr); query.setOrdering("partitionName ascending"); @SuppressWarnings("unchecked") List<MPartitionColumnStatistics> result =
query.declareParameters("java.lang.String schemaName, java.lang.String dbName," + " java.lang.String cat"); query.setOrdering("version descending"); List<MSchemaVersion> mSchemaVersions = query.setParameters(name, dbName, catName).executeList(); pm.retrieveAll(mSchemaVersions);
"java.lang.String cat"); query.setUnique(true); query.setOrdering("version descending"); query.setRange(0, 1); MSchemaVersion mSchemaVersion = (MSchemaVersion)query.execute(name, dbName, catName);
public Pagination<MCrontab> crontabPaginate(int page, int pageSize) { Query query = getPM().newQuery(MCrontab.class); query.setOrdering("id DESC"); return crontabPaginate(query, null, page, pageSize); }
public Object doInJdo(PersistenceManager pm) throws JDOException { Query query = pm.newQuery(entityClass, filter); prepareQuery(query); query.declareParameters(parameters); if (ordering != null) { query.setOrdering(ordering); } return query.executeWithArray(values); } }, true);
public Object doInJdo(PersistenceManager pm) throws JDOException { Query query = pm.newQuery(entityClass, filter); prepareQuery(query); query.declareParameters(parameters); if (ordering != null) { query.setOrdering(ordering); } return query.executeWithMap(values); } }, true);
public Object doInJdo(PersistenceManager pm) throws JDOException { Query query = (filter != null ? pm.newQuery(entityClass, filter) : pm.newQuery(entityClass)); prepareQuery(query); if (ordering != null) { query.setOrdering(ordering); } return query.execute(); } }, true);
private List<MPartition> getMPartitionsViaOrmFilter(String dbName, String tblName, List<String> partNames, Out<Query> out) { ObjectPair<Query, Map<String, String>> queryWithParams = getPartQueryWithParams(dbName, tblName, partNames); Query query = out.val = queryWithParams.getFirst(); query.setResultClass(MPartition.class); query.setClass(MPartition.class); query.setOrdering("partitionName ascending"); @SuppressWarnings("unchecked") List<MPartition> result = (List<MPartition>)query.executeWithMap(queryWithParams.getSecond()); return result; }
private List<MPartition> getMPartitionsViaOrmFilter(String dbName, String tblName, List<String> partNames, Out<Query> out) { ObjectPair<Query, Map<String, String>> queryWithParams = getPartQueryWithParams(dbName, tblName, partNames); Query query = out.val = queryWithParams.getFirst(); query.setResultClass(MPartition.class); query.setClass(MPartition.class); query.setOrdering("partitionName ascending"); @SuppressWarnings("unchecked") List<MPartition> result = (List<MPartition>)query.executeWithMap(queryWithParams.getSecond()); return result; }