Package com.google.cloud.bigquery
Class TimePartitioning
java.lang.Object
com.google.cloud.bigquery.TimePartitioning
- All Implemented Interfaces:
Serializable
Objects of this class allow to configure table partitioning based on time. By dividing a large
table into smaller partitions, you can improve query performance and reduce the number of bytes
billed by restricting the amount of data scanned.
- See Also:
-
Nested Class Summary
Modifier and TypeClassDescriptionstatic class
static enum
[Optional] The supported types are DAY, HOUR, MONTH, and YEAR, which will generate one partition per day, hour, month, and year, respectively. -
Method Summary
Modifier and TypeMethodDescriptionabstract Long
Returns the number of milliseconds for which to keep the storage for a partition.abstract String
getField()
If not set, the table is partitioned by pseudo column '_PARTITIONTIME'; if set, the table is partitioned by this field.abstract Boolean
If set to true, queries over this table require a partition filter (that can be used for partition elimination) to be specified.abstract TimePartitioning.Type
getType()
Returns the time partitioning type.static TimePartitioning.Builder
Returns aTimePartitioning
object given the time partitioning type.static TimePartitioning
of
(TimePartitioning.Type type) Returns aTimePartitioning
object given the time partitioning type.static TimePartitioning
of
(TimePartitioning.Type type, long expirationMs) Returns aTimePartitioning
object given the time partitioning type and the partition's expiration in milliseconds.abstract TimePartitioning.Builder
-
Method Details
-
getType
Returns the time partitioning type. -
getExpirationMs
Returns the number of milliseconds for which to keep the storage for a partition. When expired, the storage for the partition is reclaimed. If null, the partion does not expire. -
getField
If not set, the table is partitioned by pseudo column '_PARTITIONTIME'; if set, the table is partitioned by this field. -
getRequirePartitionFilter
If set to true, queries over this table require a partition filter (that can be used for partition elimination) to be specified. -
toBuilder
-
newBuilder
Returns aTimePartitioning
object given the time partitioning type. -
of
Returns aTimePartitioning
object given the time partitioning type. The partitions will not expire. -
of
Returns aTimePartitioning
object given the time partitioning type and the partition's expiration in milliseconds.- Parameters:
type
- the time partitioning type.expirationMs
- the number of milliseconds for which to keep the storage for a partition
-