CreateExternalTable.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 CreateExternalTableRequest : KineticaData
    {

        public struct CreateTableOptions
        {

            public const string TYPE_ID = "type_id";
        } // end struct CreateTableOptions


        public struct Options
        {

            public const string TABLE_TYPE = "table_type";
            public const string MATERIALIZED = "materialized";
            public const string LOGICAL = "logical";
            public const string LOGICAL_TMP = "logical_tmp";

            public const string FILE_TYPE = "file_type";
            public const string DELIMITED_TEXT = "delimited_text";
            public const string PARQUET = "parquet";

            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 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 BATCH_SIZE = "batch_size";

            public const string REFRESH_METHOD = "refresh_method";
            public const string MANUAL = "manual";
            public const string ON_START = "on_start";
            public const string COLUMN_FORMATS = "column_formats";
            public const string DEFAULT_COLUMN_FORMATS = "default_column_formats";

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

            public const string TEXT_HAS_HEADER = "text_has_header";

            public const string TEXT_DELIMITER = "text_delimiter";

            public const string TEXT_HEADER_PROPERTY_DELIMITER = "text_header_property_delimiter";
            public const string COLUMNS_TO_LOAD = "columns_to_load";

            public const string TEXT_COMMENT_STRING = "text_comment_string";

            public const string TEXT_NULL_STRING = "text_null_string";

            public const string TEXT_QUOTE_CHARACTER = "text_quote_character";
            public const string TEXT_ESCAPE_CHARACTER = "text_escape_character";
            public const string EXTERNAL_STORAGE_LOCATION = "external_storage_location";
            public const string S3_BUCKET_NAME = "s3_bucket_name";
            public const string S3_REGION = "s3_region";
            public const string NUM_TASKS_PER_RANK = "num_tasks_per_rank";
        } // end struct Options

        public string table_name { get; set; }
        public IList<string> filepaths { get; set; } = new List<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 CreateExternalTableRequest() { }

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

    } // end class CreateExternalTableRequest



    public class CreateExternalTableResponse : KineticaData
    {
        public string table_name { get; set; }
        public string type_id { get; set; }
        public long count_inserted { get; set; }
        public long count_skipped { get; set; }
        public long count_updated { get; set; } = -1;
        public IDictionary<string, string> info { get; set; } = new Dictionary<string, string>();

    } // end class CreateExternalTableResponse





}  // end namespace kinetica