QueryBuilder クラス

1public static void executeApexQuery(String name){
2  Wave.ProjectionNode[] projs = new Wave.ProjectionNode[]{
3    Wave.QueryBuilder.get('State').alias('State'), 
4    Wave.QueryBuilder.get('City').alias('City'), 
5    Wave.QueryBuilder.get('Revenue').avg().alias('avg_Revenue'), 
6    Wave.QueryBuilder.get('Revenue').sum().alias('sum_Revenue'),                                     
7    Wave.QueryBuilder.count().alias('count')};
8                
9  ConnectApi.LiteralJson result = Wave.QueryBuilder.load('0FbD00000004DSzKAM', '0FcD00000004FEZKA2')
10    .group(new String[]{'State', 'City'})
11    .foreach(projs)
12    .execute('q');
13  String response = result.json;
14}

1Wave.ProjectionNode[] projs = new Wave.ProjectionNode[]{Wave.QueryBuilder.count().alias('c')};
2String query = Wave.QueryBuilder.load('datasetId', 'datasetVersionId').group().foreach(projs).build('q');

1q = load "datasetId/datasetVersionId";
2q = group q by all;
3q = foreach q generate count as c;

1Wave.ProjectionNode[] projs = new Wave.ProjectionNode[]{Wave.QueryBuilder.get('Name'), Wave.QueryBuilder.get('AnnualRevenue').alias('Revenue')};
2Wave.QueryNode nodeOne = Wave.QueryBuilder.load('datasetOne','datasetVersionOne').foreach(projs);
3Wave.QueryNode nodeTwo = Wave.QueryBuilder.load('datasetTwo', 'datasetVersionTwo').foreach(projs);
4String query = Wave.QueryBuilder.union(new List<Wave.QueryNode>{nodeOne, nodeTwo}).build('q');

1qa = load "datasetOne/datasetVersionOne";
2qa = foreach q generate Name,AnnualRevenue as Revenue;
3qb = load "datasetTwo/datasetVersionTwo";
4qb = foreach q generate Name,AnnualRevenue as Revenue;
5q = union qa, qb;