Buradasın

GoogleSQL BigQuery Data Types Overview

Yapay zekadan makale özeti

Basic Types: Numeric types include INT64, NUMERIC, BIGNUMERIC, and FLOAT64
Boolean values are sorted: NULL, FALSE, TRUE
String and bytes types are separate and use UTF-8 encoding
Array Types: Arrays can contain zero or more elements of same type
Arrays can be NULL, but translate to empty array in results
Arrays of arrays are not allowed, use structs instead
Date and Time Types: Date type represents Gregorian calendar dates independent of time zone
Datetime type includes date and time components
Interval type represents durations without specific time points
Geography and JSON Types: Geography type supports points, linestrings, polygons, and collections
JSON type preserves boolean, string, and null values exactly
JSON supports up to 500 levels of nesting
Data Type Properties: All types are nullable
Orderable types can be used in ORDER BY clauses
Groupable types support GROUP BY, DISTINCT, and PARTITION BY
Comparable types support equality comparisons
Collatable types support string sorting and comparison