public class AggregateStatisticsByRangeRequest extends Object implements org.apache.avro.generic.IndexedRecord
GPUdb.aggregateStatisticsByRange(AggregateStatisticsByRangeRequest)
.
options
. The weighted average is then defined
as the sum of the products of the value column times the weight column divided by the sum of the weight column.
options
bin_values specifies a list of binning column values.
Binning-columns whose value matches the nth member of the bin_values list are placed in the nth bin. When a list is provided the
binning-column must be of type string or int.Modifier and Type | Class and Description |
---|---|
static class |
AggregateStatisticsByRangeRequest.Options
Map of optional parameters:
additional_column_names: A list of comma separated value-column names over which statistics can be accumulated along with the primary value_column. |
Constructor and Description |
---|
AggregateStatisticsByRangeRequest()
Constructs an AggregateStatisticsByRangeRequest object with default parameters.
|
AggregateStatisticsByRangeRequest(String tableName,
String selectExpression,
String columnName,
String valueColumnName,
String stats,
double start,
double end,
double interval,
Map<String,String> options)
Constructs an AggregateStatisticsByRangeRequest object with the specified parameters.
|
Modifier and Type | Method and Description |
---|---|
boolean |
equals(Object obj) |
Object |
get(int index)
This method supports the Avro framework and is not intended to be called directly by the user.
|
static org.apache.avro.Schema |
getClassSchema()
This method supports the Avro framework and is not intended to be called directly by the user.
|
String |
getColumnName() |
double |
getEnd() |
double |
getInterval() |
Map<String,String> |
getOptions() |
org.apache.avro.Schema |
getSchema()
This method supports the Avro framework and is not intended to be called directly by the user.
|
String |
getSelectExpression() |
double |
getStart() |
String |
getStats() |
String |
getTableName() |
String |
getValueColumnName() |
int |
hashCode() |
void |
put(int index,
Object value)
This method supports the Avro framework and is not intended to be called directly by the user.
|
AggregateStatisticsByRangeRequest |
setColumnName(String columnName) |
AggregateStatisticsByRangeRequest |
setEnd(double end) |
AggregateStatisticsByRangeRequest |
setInterval(double interval) |
AggregateStatisticsByRangeRequest |
setOptions(Map<String,String> options) |
AggregateStatisticsByRangeRequest |
setSelectExpression(String selectExpression) |
AggregateStatisticsByRangeRequest |
setStart(double start) |
AggregateStatisticsByRangeRequest |
setStats(String stats) |
AggregateStatisticsByRangeRequest |
setTableName(String tableName) |
AggregateStatisticsByRangeRequest |
setValueColumnName(String valueColumnName) |
String |
toString() |
public AggregateStatisticsByRangeRequest()
public AggregateStatisticsByRangeRequest(String tableName, String selectExpression, String columnName, String valueColumnName, String stats, double start, double end, double interval, Map<String,String> options)
tableName
- Name of the table on which the ranged-statistics operation will be performed.selectExpression
- For a non-empty expression statistics are calculated for those records for which the expression is
true.columnName
- Name of the binning-column used to divide the set samples into bins.valueColumnName
- Name of the value-column for which statistics are to be computed.stats
- A string of comma separated list of the statistics to calculate, e.g. 'sum,mean'. Available statistics: mean,
stdv (standard deviation), variance, skew, kurtosis, sum.start
- The lower bound of the binning-column.end
- The upper bound of the binning-column.interval
- The interval of a bin. Set members fall into bin i if the binning-column falls in the range
[start+interval``*``i, start+interval``*``(i+1)).options
- Map of optional parameters:
public static org.apache.avro.Schema getClassSchema()
public String getTableName()
public AggregateStatisticsByRangeRequest setTableName(String tableName)
tableName
- Name of the table on which the ranged-statistics operation will be performed.this
to mimic the builder pattern.public String getSelectExpression()
public AggregateStatisticsByRangeRequest setSelectExpression(String selectExpression)
selectExpression
- For a non-empty expression statistics are calculated for those records for which the expression is
true.this
to mimic the builder pattern.public String getColumnName()
public AggregateStatisticsByRangeRequest setColumnName(String columnName)
columnName
- Name of the binning-column used to divide the set samples into bins.this
to mimic the builder pattern.public String getValueColumnName()
public AggregateStatisticsByRangeRequest setValueColumnName(String valueColumnName)
valueColumnName
- Name of the value-column for which statistics are to be computed.this
to mimic the builder pattern.public String getStats()
public AggregateStatisticsByRangeRequest setStats(String stats)
stats
- A string of comma separated list of the statistics to calculate, e.g. 'sum,mean'. Available statistics: mean,
stdv (standard deviation), variance, skew, kurtosis, sum.this
to mimic the builder pattern.public double getStart()
public AggregateStatisticsByRangeRequest setStart(double start)
start
- The lower bound of the binning-column.this
to mimic the builder pattern.public double getEnd()
public AggregateStatisticsByRangeRequest setEnd(double end)
end
- The upper bound of the binning-column.this
to mimic the builder pattern.public double getInterval()
public AggregateStatisticsByRangeRequest setInterval(double interval)
interval
- The interval of a bin. Set members fall into bin i if the binning-column falls in the range
[start+interval``*``i, start+interval``*``(i+1)).this
to mimic the builder pattern.public Map<String,String> getOptions()
public AggregateStatisticsByRangeRequest setOptions(Map<String,String> options)
options
- Map of optional parameters:
this
to mimic the builder pattern.public org.apache.avro.Schema getSchema()
getSchema
in interface org.apache.avro.generic.GenericContainer
public Object get(int index)
get
in interface org.apache.avro.generic.IndexedRecord
index
- the position of the field to getIndexOutOfBoundsException
public void put(int index, Object value)
put
in interface org.apache.avro.generic.IndexedRecord
index
- the position of the field to setvalue
- the value to setIndexOutOfBoundsException
Copyright © 2016. All rights reserved.