CreateTableExternal.cs

Go to the documentation of this file.

/*
 *  This file was autogenerated by the Kinetica schema processor.
 *
 *  DO NOT EDIT DIRECTLY.
 */

using System.Collections.Generic;

namespace kinetica;

public class CreateTableExternalRequest : KineticaData
{
    public struct CreateTableOptions
    {
        public const string TYPE_ID = "type_id";

        public const string NO_ERROR_IF_EXISTS = "no_error_if_exists";

        public const string TRUE = "true";
        public const string FALSE = "false";

        public const string IS_REPLICATED = "is_replicated";

        public const string FOREIGN_KEYS = "foreign_keys";

        public const string FOREIGN_SHARD_KEY = "foreign_shard_key";

        public const string PARTITION_TYPE = "partition_type";

        public const string RANGE = "RANGE";

        public const string INTERVAL = "INTERVAL";

        public const string LIST = "LIST";

        public const string HASH = "HASH";

        public const string SERIES = "SERIES";

        public const string PARTITION_KEYS = "partition_keys";

        public const string PARTITION_DEFINITIONS = "partition_definitions";

        public const string IS_AUTOMATIC_PARTITION = "is_automatic_partition";

        public const string TTL = "ttl";

        public const string CHUNK_SIZE = "chunk_size";

        public const string CHUNK_COLUMN_MAX_MEMORY = "chunk_column_max_memory";

        public const string CHUNK_MAX_MEMORY = "chunk_max_memory";

        public const string IS_RESULT_TABLE = "is_result_table";

        public const string STRATEGY_DEFINITION = "strategy_definition";

        public const string COMPRESSION_CODEC = "compression_codec";
    } // end struct CreateTableOptions

    public struct Options
    {
        public const string BAD_RECORD_TABLE_NAME = "bad_record_table_name";

        public const string BAD_RECORD_TABLE_LIMIT = "bad_record_table_limit";

        public const string BAD_RECORD_TABLE_LIMIT_PER_INPUT = "bad_record_table_limit_per_input";

        public const string BATCH_SIZE = "batch_size";

        public const string COLUMN_FORMATS = "column_formats";

        public const string COLUMNS_TO_LOAD = "columns_to_load";

        public const string COLUMNS_TO_SKIP = "columns_to_skip";

        public const string COMPRESSION_TYPE = "compression_type";

        public const string NONE = "none";

        public const string AUTO = "auto";

        public const string GZIP = "gzip";

        public const string BZIP2 = "bzip2";

        public const string DATASOURCE_NAME = "datasource_name";

        public const string DEFAULT_COLUMN_FORMATS = "default_column_formats";

        public const string DATALAKE_CATALOG = "datalake_catalog";

        public const string DATALAKE_PATH = "datalake_path";

        public const string DATALAKE_SNAPSHOT = "datalake_snapshot";

        public const string ERROR_HANDLING = "error_handling";

        public const string PERMISSIVE = "permissive";

        public const string IGNORE_BAD_RECORDS = "ignore_bad_records";

        public const string ABORT = "abort";

        public const string EXTERNAL_TABLE_TYPE = "external_table_type";

        public const string MATERIALIZED = "materialized";

        public const string LOGICAL = "logical";

        public const string FILE_TYPE = "file_type";

        public const string AVRO = "avro";

        public const string DELIMITED_TEXT = "delimited_text";

        public const string GDB = "gdb";

        public const string JSON = "json";

        public const string PARQUET = "parquet";

        public const string SHAPEFILE = "shapefile";

        public const string FLATTEN_COLUMNS = "flatten_columns";

        public const string TRUE = "true";

        public const string FALSE = "false";

        public const string GDAL_CONFIGURATION_OPTIONS = "gdal_configuration_options";

        public const string IGNORE_EXISTING_PK = "ignore_existing_pk";

        public const string INGESTION_MODE = "ingestion_mode";

        public const string FULL = "full";

        public const string DRY_RUN = "dry_run";

        public const string TYPE_INFERENCE_ONLY = "type_inference_only";

        public const string JDBC_FETCH_SIZE = "jdbc_fetch_size";

        public const string KAFKA_CONSUMERS_PER_RANK = "kafka_consumers_per_rank";

        public const string KAFKA_GROUP_ID = "kafka_group_id";

        public const string KAFKA_OFFSET_RESET_POLICY = "kafka_offset_reset_policy";

        public const string EARLIEST = "earliest";
        public const string LATEST = "latest";

        public const string KAFKA_OPTIMISTIC_INGEST = "kafka_optimistic_ingest";

        public const string KAFKA_SUBSCRIPTION_CANCEL_AFTER = "kafka_subscription_cancel_after";

        public const string KAFKA_TYPE_INFERENCE_FETCH_TIMEOUT = "kafka_type_inference_fetch_timeout";

        public const string LAYER = "layer";

        public const string LOADING_MODE = "loading_mode";

        public const string HEAD = "head";

        public const string DISTRIBUTED_SHARED = "distributed_shared";

        public const string DISTRIBUTED_LOCAL = "distributed_local";

        public const string LOCAL_TIME_OFFSET = "local_time_offset";

        public const string MAX_RECORDS_TO_LOAD = "max_records_to_load";

        public const string NUM_TASKS_PER_RANK = "num_tasks_per_rank";

        public const string POLL_INTERVAL = "poll_interval";

        public const string PRIMARY_KEYS = "primary_keys";

        public const string REFRESH_METHOD = "refresh_method";

        public const string MANUAL = "manual";

        public const string ON_START = "on_start";

        public const string SCHEMA_REGISTRY_CONNECTION_RETRIES = "schema_registry_connection_retries";

        public const string SCHEMA_REGISTRY_CONNECTION_TIMEOUT = "schema_registry_connection_timeout";

        public const string SCHEMA_REGISTRY_MAX_CONSECUTIVE_CONNECTION_FAILURES = "schema_registry_max_consecutive_connection_failures";

        public const string MAX_CONSECUTIVE_INVALID_SCHEMA_FAILURE = "max_consecutive_invalid_schema_failure";

        public const string SCHEMA_REGISTRY_SCHEMA_NAME = "schema_registry_schema_name";

        public const string SHARD_KEYS = "shard_keys";

        public const string SKIP_LINES = "skip_lines";

        public const string START_OFFSETS = "start_offsets";

        public const string SUBSCRIBE = "subscribe";

        public const string TABLE_INSERT_MODE = "table_insert_mode";

        public const string SINGLE = "single";

        public const string TABLE_PER_FILE = "table_per_file";

        public const string TEXT_COMMENT_STRING = "text_comment_string";

        public const string TEXT_DELIMITER = "text_delimiter";

        public const string TEXT_ESCAPE_CHARACTER = "text_escape_character";

        public const string TEXT_HAS_HEADER = "text_has_header";

        public const string TEXT_HEADER_PROPERTY_DELIMITER = "text_header_property_delimiter";

        public const string TEXT_NULL_STRING = "text_null_string";

        public const string TEXT_QUOTE_CHARACTER = "text_quote_character";

        public const string TEXT_SEARCH_COLUMNS = "text_search_columns";

        public const string TEXT_SEARCH_MIN_COLUMN_LENGTH = "text_search_min_column_length";

        public const string TRIM_SPACE = "trim_space";

        public const string TRUNCATE_STRINGS = "truncate_strings";

        public const string TRUNCATE_TABLE = "truncate_table";

        public const string TYPE_INFERENCE_MAX_RECORDS_READ = "type_inference_max_records_read";

        public const string TYPE_INFERENCE_MODE = "type_inference_mode";

        public const string ACCURACY = "accuracy";

        public const string SPEED = "speed";

        public const string REMOTE_QUERY = "remote_query";

        public const string REMOTE_QUERY_FILTER_COLUMN = "remote_query_filter_column";

        public const string REMOTE_QUERY_INCREASING_COLUMN = "remote_query_increasing_column";

        public const string REMOTE_QUERY_PARTITION_COLUMN = "remote_query_partition_column";

        public const string UPDATE_ON_EXISTING_PK = "update_on_existing_pk";
    } // end struct Options

    public string table_name { get; set; }

    public IList<string> filepaths { get; set; } = new List<string>();

    public IDictionary<string, IDictionary<string, string>> modify_columns { get; set; } = new Dictionary<string, IDictionary<string, string>>();

    public IDictionary<string, string> create_table_options { get; set; } = new Dictionary<string, string>();

    public IDictionary<string, string> options { get; set; } = new Dictionary<string, string>();

    public CreateTableExternalRequest() { }

    public CreateTableExternalRequest( string table_name,
                                       IList<string> filepaths,
                                       IDictionary<string, IDictionary<string, string>> modify_columns = null,
                                       IDictionary<string, string> create_table_options = null,
                                       IDictionary<string, string> options = null)
    {
        this.table_name = table_name ?? "";
        this.filepaths = filepaths ?? new List<string>();
        this.modify_columns = modify_columns ?? new Dictionary<string, IDictionary<string, string>>();
        this.create_table_options = create_table_options ?? new Dictionary<string, string>();
        this.options = options ?? new Dictionary<string, string>();
    } // end constructor
} // end class CreateTableExternalRequest

public class CreateTableExternalResponse : KineticaData
{
    public string table_name { get; set; }

    public string type_id { get; set; }

    public string type_definition { get; set; }

    public string type_label { get; set; }

    public IDictionary<string, IList<string>> type_properties { get; set; } = new Dictionary<string, IList<string>>();

    public long count_inserted { get; set; }

    public long count_skipped { get; set; }

    public long count_updated { get; set; }

    public IDictionary<string, string> info { get; set; } = new Dictionary<string, string>();

    public IList<string> files { get; set; } = new List<string>();
} // end class CreateTableExternalResponse