column#    column_name          hive_datatype

===============================================================

1          registration_dttm    timestamp

2          id                   int

3          first_name           string

4          last_name            string

5          email                string

6          gender               string

7          ip_address           string

8          cc                   string

9          country              string

10         birthdate            string

11         salary               double

12         title                string

CREATE EXTERNAL TABLE avro_ex_test (

     registration_dttm     TIMESTAMP,

     id                    INTEGER,

     first_name            VARCHAR(50),

     last_name             VARCHAR(50),

     email                 VARCHAR(50),

     gender                VARCHAR(50),

     ip_address            VARCHAR(50),

     cc                    VARCHAR(50),

     country               VARCHAR(50),

     birthdate             VARCHAR(50),

     salary                DECIMAL(18,2),

     title                 VARCHAR(50)

) USING SPARK WITH

REFERENCE='abfs://loadtest@avalanchetest.dfs.core.windows.net/userdata.avro',

FORMAT='com.databricks.spark.avro'

OPTIONS=('header' = 'true');

CREATE TABLE avro_test(

     registration_dttm     TIMESTAMP,

     id                    INTEGER,

     first_name            VARCHAR(50),

     last_name             VARCHAR(50),

     email                 VARCHAR(50),

     gender                VARCHAR(50),

     ip_address            VARCHAR(50),

     cc                    VARCHAR(50),

     country               VARCHAR(50),

     birthdate             VARCHAR(50),

     salary                DECIMAL(18,2),

     title                 VARCHAR(50)

) WITH STRUCTURE=X100;

INSERT INTO avro_test SELECT * FROM avro_ex_test