sql-tests.testcases.system.selectInformationSchemaColumns.result Maven / Gradle / Ivy
-- delimiter: |; trimValues:true;
system| information_schema| applicable_roles| grantee| varchar| YES| null| null|
system| information_schema| applicable_roles| grantee_type| varchar| YES| null| null|
system| information_schema| applicable_roles| role_name| varchar| YES| null| null|
system| information_schema| applicable_roles| is_grantable| varchar| YES| null| null|
system| information_schema| columns| table_catalog| varchar| YES| null| null|
system| information_schema| columns| table_schema| varchar| YES| null| null|
system| information_schema| columns| table_name| varchar| YES| null| null|
system| information_schema| columns| column_name| varchar| YES| null| null|
system| information_schema| columns| ordinal_position| bigint| YES| null| null|
system| information_schema| columns| column_default| varchar| YES| null| null|
system| information_schema| columns| is_nullable| varchar| YES| null| null|
system| information_schema| columns| data_type| varchar| YES| null| null|
system| information_schema| enabled_roles| role_name| varchar| YES| null| null|
system| information_schema| role_authorization_descriptors| role_name| varchar| YES| null| null|
system| information_schema| role_authorization_descriptors| grantor| varchar| YES| null| null|
system| information_schema| role_authorization_descriptors| grantor_type| varchar| YES| null| null|
system| information_schema| role_authorization_descriptors| grantee| varchar| YES| null| null|
system| information_schema| role_authorization_descriptors| grantee_type| varchar| YES| null| null|
system| information_schema| role_authorization_descriptors| is_grantable| varchar| YES| null| null|
system| information_schema| roles| role_name| varchar| YES| null| null|
system| information_schema| schemata| catalog_name| varchar| YES| null| null|
system| information_schema| schemata| schema_name| varchar| YES| null| null|
system| information_schema| table_privileges| grantor| varchar| YES| null| null|
system| information_schema| table_privileges| grantor_type| varchar| YES| null| null|
system| information_schema| table_privileges| grantee| varchar| YES| null| null|
system| information_schema| table_privileges| grantee_type| varchar| YES| null| null|
system| information_schema| table_privileges| table_catalog| varchar| YES| null| null|
system| information_schema| table_privileges| table_schema| varchar| YES| null| null|
system| information_schema| table_privileges| table_name| varchar| YES| null| null|
system| information_schema| table_privileges| privilege_type| varchar| YES| null| null|
system| information_schema| table_privileges| is_grantable| varchar| YES| null| null|
system| information_schema| table_privileges| with_hierarchy| varchar| YES| null| null|
system| information_schema| tables| table_catalog| varchar| YES| null| null|
system| information_schema| tables| table_schema| varchar| YES| null| null|
system| information_schema| tables| table_name| varchar| YES| null| null|
system| information_schema| tables| table_type| varchar| YES| null| null|
system| information_schema| views| table_catalog| varchar| YES| null| null|
system| information_schema| views| table_schema| varchar| YES| null| null|
system| information_schema| views| table_name| varchar| YES| null| null|
system| information_schema| views| view_definition| varchar| YES| null| null|
system| metadata| analyze_properties| catalog_name| varchar| YES| null| null|
system| metadata| analyze_properties| property_name| varchar| YES| null| null|
system| metadata| analyze_properties| default_value| varchar| YES| null| null|
system| metadata| analyze_properties| type| varchar| YES| null| null|
system| metadata| analyze_properties| description| varchar| YES| null| null|
system| metadata| catalogs| catalog_name| varchar| YES| null| null|
system| metadata| catalogs| connector_id| varchar| YES| null| null|
system| metadata| column_properties| catalog_name| varchar| YES| null| null|
system| metadata| column_properties| property_name| varchar| YES| null| null|
system| metadata| column_properties| default_value| varchar| YES| null| null|
system| metadata| column_properties| type| varchar| YES| null| null|
system| metadata| column_properties| description| varchar| YES| null| null|
system| metadata| schema_properties| catalog_name| varchar| YES| null| null|
system| metadata| schema_properties| property_name| varchar| YES| null| null|
system| metadata| schema_properties| default_value| varchar| YES| null| null|
system| metadata| schema_properties| type| varchar| YES| null| null|
system| metadata| schema_properties| description| varchar| YES| null| null|
system| metadata| table_comments| catalog_name| varchar| YES| null| null|
system| metadata| table_comments| schema_name| varchar| YES| null| null|
system| metadata| table_comments| table_name| varchar| YES| null| null|
system| metadata| table_comments| comment| varchar| YES| null| null|
system| metadata| table_properties| catalog_name| varchar| YES| null| null|
system| metadata| table_properties| property_name| varchar| YES| null| null|
system| metadata| table_properties| default_value| varchar| YES| null| null|
system| metadata| table_properties| type| varchar| YES| null| null|
system| metadata| table_properties| description| varchar| YES| null| null|
system| runtime| nodes| node_id| varchar| YES| null| null|
system| runtime| nodes| http_uri| varchar| YES| null| null|
system| runtime| nodes| node_version| varchar| YES| null| null|
system| runtime| nodes| coordinator| boolean| YES| null| null|
system| runtime| nodes| state| varchar| YES| null| null|
system| runtime| optimizer_rule_stats| rule_name| varchar| YES| null| null|
system| runtime| optimizer_rule_stats| invocations| bigint| YES| null| null|
system| runtime| optimizer_rule_stats| matches| bigint| YES| null| null|
system| runtime| optimizer_rule_stats| failures| bigint| YES| null| null|
system| runtime| optimizer_rule_stats| average_time| double| YES| null| null|
system| runtime| optimizer_rule_stats| time_distribution_percentiles| map(double, double)| YES| null| null|
system| runtime| queries| query_id| varchar| YES| null| null|
system| runtime| queries| state| varchar| YES| null| null|
system| runtime| queries| user| varchar| YES| null| null|
system| runtime| queries| source| varchar| YES| null| null|
system| runtime| queries| query| varchar| YES| null| null|
system| runtime| queries| resource_group_id| array(varchar)| YES| null| null|
system| runtime| queries| queued_time_ms| bigint| YES| null| null|
system| runtime| queries| analysis_time_ms| bigint| YES| null| null|
system| runtime| queries| planning_time_ms| bigint| YES| null| null|
system| runtime| queries| created| timestamp(3) with time zone| YES| null| null|
system| runtime| queries| started| timestamp(3) with time zone| YES| null| null|
system| runtime| queries| last_heartbeat| timestamp(3) with time zone| YES| null| null|
system| runtime| queries| end| timestamp(3) with time zone| YES| null| null|
system| runtime| queries| error_type| varchar| YES| null| null|
system| runtime| queries| error_code| varchar| YES| null| null|
system| runtime| tasks| node_id| varchar| YES| null| null|
system| runtime| tasks| task_id| varchar| YES| null| null|
system| runtime| tasks| stage_id| varchar| YES| null| null|
system| runtime| tasks| query_id| varchar| YES| null| null|
system| runtime| tasks| state| varchar| YES| null| null|
system| runtime| tasks| splits| bigint| YES| null| null|
system| runtime| tasks| queued_splits| bigint| YES| null| null|
system| runtime| tasks| running_splits| bigint| YES| null| null|
system| runtime| tasks| completed_splits| bigint| YES| null| null|
system| runtime| tasks| split_scheduled_time_ms| bigint| YES| null| null|
system| runtime| tasks| split_cpu_time_ms| bigint| YES| null| null|
system| runtime| tasks| split_blocked_time_ms| bigint| YES| null| null|
system| runtime| tasks| raw_input_bytes| bigint| YES| null| null|
system| runtime| tasks| raw_input_rows| bigint| YES| null| null|
system| runtime| tasks| processed_input_bytes| bigint| YES| null| null|
system| runtime| tasks| processed_input_rows| bigint| YES| null| null|
system| runtime| tasks| output_bytes| bigint| YES| null| null|
system| runtime| tasks| output_rows| bigint| YES| null| null|
system| runtime| tasks| physical_input_bytes| bigint| YES| null| null|
system| runtime| tasks| physical_written_bytes| bigint| YES| null| null|
system| runtime| tasks| created| timestamp(3) with time zone| YES| null| null|
system| runtime| tasks| start| timestamp(3) with time zone| YES| null| null|
system| runtime| tasks| last_heartbeat| timestamp(3) with time zone| YES| null| null|
system| runtime| tasks| end| timestamp(3) with time zone| YES| null| null|
system| runtime| transactions| transaction_id| varchar| YES| null| null|
system| runtime| transactions| isolation_level| varchar| YES| null| null|
system| runtime| transactions| read_only| boolean| YES| null| null|
system| runtime| transactions| auto_commit_context| boolean| YES| null| null|
system| runtime| transactions| create_time| timestamp(3) with time zone| YES| null| null|
system| runtime| transactions| idle_time_secs| bigint| YES| null| null|
system| runtime| transactions| written_catalog| varchar| YES| null| null|
system| runtime| transactions| catalogs| array(varchar)| YES| null| null|