GPUdb C++ API
Version 7.0.19.0
|
Variables | |
const std::string | DATA |
Default property for all numeric and string type columns; makes the column available for GPU queries. More... | |
const std::string | TEXT_SEARCH |
Valid only for 'string' columns. More... | |
const std::string | STORE_ONLY |
Persist the column value but do not make it available to queries (e.g. More... | |
const std::string | DISK_OPTIMIZED |
Works in conjunction with the data property for string columns. More... | |
const std::string | TIMESTAMP |
Valid only for 'long' columns. More... | |
const std::string | ULONG |
Valid only for 'string' columns. More... | |
const std::string | DECIMAL |
Valid only for 'string' columns. More... | |
const std::string | DATE |
Valid only for 'string' columns. More... | |
const std::string | TIME |
Valid only for 'string' columns. More... | |
const std::string | DATETIME |
Valid only for 'string' columns. More... | |
const std::string | CHAR1 |
This property provides optimized memory, disk and query performance for string columns. More... | |
const std::string | CHAR2 |
This property provides optimized memory, disk and query performance for string columns. More... | |
const std::string | CHAR4 |
This property provides optimized memory, disk and query performance for string columns. More... | |
const std::string | CHAR8 |
This property provides optimized memory, disk and query performance for string columns. More... | |
const std::string | CHAR16 |
This property provides optimized memory, disk and query performance for string columns. More... | |
const std::string | CHAR32 |
This property provides optimized memory, disk and query performance for string columns. More... | |
const std::string | CHAR64 |
This property provides optimized memory, disk and query performance for string columns. More... | |
const std::string | CHAR128 |
This property provides optimized memory, disk and query performance for string columns. More... | |
const std::string | CHAR256 |
This property provides optimized memory, disk and query performance for string columns. More... | |
const std::string | INT8 |
This property provides optimized memory and query performance for int columns. More... | |
const std::string | INT16 |
This property provides optimized memory and query performance for int columns. More... | |
const std::string | IPV4 |
This property provides optimized memory, disk and query performance for string columns representing IPv4 addresses (i.e. More... | |
const std::string | WKT |
Valid only for 'string' and 'bytes' columns. More... | |
const std::string | PRIMARY_KEY |
This property indicates that this column will be part of (or the entire) primary key. More... | |
const std::string | SHARD_KEY |
This property indicates that this column will be part of (or the entire) shard key. More... | |
const std::string | NULLABLE |
This property indicates that this column is nullable. More... | |
const std::string | DICT |
This property indicates that this column should be dictionary encoded. More... | |
const std::string | INIT_WITH_NOW |
For 'date', 'time', 'datetime', or 'timestamp' column types, replace empty strings and invalid timestamps with 'NOW()' upon insert. More... | |
const std::string gpudb::ColumnProperty::CHAR1 |
This property provides optimized memory, disk and query performance for string columns.
Strings with this property must be no longer than 1 character.
const std::string gpudb::ColumnProperty::CHAR128 |
This property provides optimized memory, disk and query performance for string columns.
Strings with this property must be no longer than 128 characters.
const std::string gpudb::ColumnProperty::CHAR16 |
This property provides optimized memory, disk and query performance for string columns.
Strings with this property must be no longer than 16 characters.
const std::string gpudb::ColumnProperty::CHAR2 |
This property provides optimized memory, disk and query performance for string columns.
Strings with this property must be no longer than 2 characters.
const std::string gpudb::ColumnProperty::CHAR256 |
This property provides optimized memory, disk and query performance for string columns.
Strings with this property must be no longer than 256 characters.
const std::string gpudb::ColumnProperty::CHAR32 |
This property provides optimized memory, disk and query performance for string columns.
Strings with this property must be no longer than 32 characters.
const std::string gpudb::ColumnProperty::CHAR4 |
This property provides optimized memory, disk and query performance for string columns.
Strings with this property must be no longer than 4 characters.
const std::string gpudb::ColumnProperty::CHAR64 |
This property provides optimized memory, disk and query performance for string columns.
Strings with this property must be no longer than 64 characters.
const std::string gpudb::ColumnProperty::CHAR8 |
This property provides optimized memory, disk and query performance for string columns.
Strings with this property must be no longer than 8 characters.
const std::string gpudb::ColumnProperty::DATA |
Default property for all numeric and string type columns; makes the column available for GPU queries.
const std::string gpudb::ColumnProperty::DATE |
Valid only for 'string' columns.
Indicates that this field represents a date and will be provided in the format 'YYYY-MM-DD'. The allowable range is 1000-01-01 through 2900-01-01. This property is mutually exclusive with the text_search property.
const std::string gpudb::ColumnProperty::DATETIME |
Valid only for 'string' columns.
Indicates that this field represents a datetime and will be provided in the format 'YYYY-MM-DD HH:MM:SS.mmm'. The allowable range is 1000-01-01 00:00:00.000 through 2900-01-01 23:59:59.999. This property is mutually exclusive with the text_search property.
const std::string gpudb::ColumnProperty::DECIMAL |
Valid only for 'string' columns.
It represents a SQL type NUMERIC(19, 4) data type. There can be up to 15 digits before the decimal point and up to four digits in the fractional part. The value can be positive or negative (indicated by a minus sign at the beginning). This property is mutually exclusive with the text_search property.
const std::string gpudb::ColumnProperty::DICT |
This property indicates that this column should be dictionary encoded.
It can only be used in conjunction with restricted string (charN), int, long or date columns. Dictionary encoding is best for columns where the cardinality (the number of unique values) is expected to be low. This property can save a large amount of memory.
const std::string gpudb::ColumnProperty::DISK_OPTIMIZED |
Works in conjunction with the data property for string columns.
This property reduces system disk usage by disabling reverse string lookups. Queries like /filter, /filter/bylist, and /filter/byvalue work as usual but /aggregate/unique and /aggregate/groupby are not allowed on columns with this property.
const std::string gpudb::ColumnProperty::INIT_WITH_NOW |
For 'date', 'time', 'datetime', or 'timestamp' column types, replace empty strings and invalid timestamps with 'NOW()' upon insert.
const std::string gpudb::ColumnProperty::INT16 |
This property provides optimized memory and query performance for int columns.
Ints with this property must be between -32768 and +32767 (inclusive)
const std::string gpudb::ColumnProperty::INT8 |
This property provides optimized memory and query performance for int columns.
Ints with this property must be between -128 and +127 (inclusive)
const std::string gpudb::ColumnProperty::IPV4 |
This property provides optimized memory, disk and query performance for string columns representing IPv4 addresses (i.e.
192.168.1.1). Strings with this property must be of the form: A.B.C.D where A, B, C and D are in the range of 0-255.
const std::string gpudb::ColumnProperty::NULLABLE |
This property indicates that this column is nullable.
However, setting this property is insufficient for making the column nullable. The user must declare the type of the column as a union between its regular type and 'null' in the avro schema for the record type in typeDefinition. For example, if a column is of type integer and is nullable, then the entry for the column in the avro schema must be: ['int', 'null'].
The C++, C#, Java, and Python APIs have built-in convenience for bypassing setting the avro schema by hand. For those languages, one can use this property as usual and not have to worry about the avro schema for the record.
const std::string gpudb::ColumnProperty::PRIMARY_KEY |
This property indicates that this column will be part of (or the entire) primary key.
const std::string gpudb::ColumnProperty::SHARD_KEY |
This property indicates that this column will be part of (or the entire) shard key.
const std::string gpudb::ColumnProperty::STORE_ONLY |
Persist the column value but do not make it available to queries (e.g.
/filter)-i.e. it is mutually exclusive to the data property. Any 'bytes' type column must have a store_only property. This property reduces system memory usage.
const std::string gpudb::ColumnProperty::TEXT_SEARCH |
Valid only for 'string' columns.
Enables full text search for string columns. Can be set independently of data and store_only.
const std::string gpudb::ColumnProperty::TIME |
Valid only for 'string' columns.
Indicates that this field represents a time-of-day and will be provided in the format 'HH:MM:SS.mmm'. The allowable range is 00:00:00.000 through 23:59:59.999. This property is mutually exclusive with the text_search property.
const std::string gpudb::ColumnProperty::TIMESTAMP |
Valid only for 'long' columns.
Indicates that this field represents a timestamp and will be provided in milliseconds since the Unix epoch: 00:00:00 Jan 1 1970. Dates represented by a timestamp must fall between the year 1000 and the year 2900.
const std::string gpudb::ColumnProperty::ULONG |
Valid only for 'string' columns.
It represents an unsigned long integer data type. The string can only be interpreted as an unsigned long data type with minimum value of zero, and maximum value of 18446744073709551615.
const std::string gpudb::ColumnProperty::WKT |
Valid only for 'string' and 'bytes' columns.
Indicates that this field contains geospatial geometry objects in Well-Known Text (WKT) or Well-Known Binary (WKB) format.