Error while importing hive sql using the Import external metadata

Hi,

I am trying to import a hive sql file using the import->external metadata option but the physical model does not get created.

It fails with a warning ->"Couldn't recognize the CREATE ....sql"

When i try it again i get different errors "/users/documents/xyz.pdm is not writable"

Please advise.

Thanks,

Raj

Parents Reply
  • volte_calls_geolocation.sql
    CREATE EXTERNAL TABLE integration.volte_calls_geolocation(                                                          
       cdr_unique_id string Comment 'Unique identifier for each LSR record' ,                                                                                             
       cdr_a_number string COMMENT 'The calling or originating directory number' ,                                                                                              
       cdr_b_number string COMMENT 'The Called or Terminating directory number.' ,                                                                                              
       cdr_msisdn string COMMENT 'Mobile Subscriber International Directory Number' ,                                                                                                
       cdr_node_part string COMMENT 'Node Partition of the CDR' ,                                                                                             
       cdr_fail_category_type_name string COMMENT 'Different fail category types.The values are 0 - Normal,1 - MSS Drop,2 - TAS_AFT_SRVCC_Drop,3 - TAS_LTE_SRVCC_Drop,4 - TAS_Net_Drop,5 - TAS_Other_Drop,6 - TAS_SRVCC_Drop' ,                                                                               
       cdr_first_voice_tech_desc string comment 'Description of each voice technology used, e.g. 2G, 3G, VoLTE, WFC, etc.' ,                                                                                 
       cdr_call_duration_sec string COMMENT 'Duration of the call in seconds for each CDR' ,                                                                                     
       cdr_direction string COMMENT 'This indicates the direction of the call. 1 = mobile originating, 2 = mobile terminating.' ,                                                                                             
       cdr_time_to_alert_millisec string COMMENT 'The date and time that the voice call disconnected.' ,                                                                                
       cdr_time_to_answer_millisec string COMMENT 'Number of sections or fraction thereof from the time the user equipment was alterted until the subscriber answered.' ,                                                                               
       cdr_time_to_disconnect_millisec string Comment 'Number of sections or fraction thereof from the time the subscriber answered until the call was disconnected, regardless of the cause for termination.' ,                                                                           
       cdr_time_to_page_millisec string Comment 'The date and time that the voice call was answered.' ,                                                                                 
       cdr_cft1 string Comment 'These values give the Call Failed termination codes for different sources.' ,                                                                                                  
       cdr_cft2 string Comment 'An alpha numeric column that contains a CFT code.' ,                                                                                                  
       cdr_disconnecting_party string Comment 'This indicates which party disconnected. The values are 1 = originating, 2 = terminating.' ,                                                                                   
       cdr_device_fullname string Comment 'Fullname of the device, e.g. Apple iPhone 5s.' ,                                                                                       
       cdr_device_index string Comment 'A unique number assigned to every entry of the TAC Reference table.' ,                                                                                          
       cdr_market string Comment 'The Market served by this cell sector.' ,                                                                                                
       cdr_region string Comment 'The region served by this cell sector' ,                                                                                                
       cdr_first_cellname string Comment 'A descriptive name given to the cell sector.' ,                                                                                        
       cdr_utc_start_date string Comment 'This is the time(UTC) of initial connection to the network.' ,                                                                                        
       cdr_utc_end_date string Comment 'The time in UTC that elapsed when the subscriber answered the call until the call was disconnected' ,                                                                                          
       cdr_local_start_date string Comment 'This is the time(local time) of initial connection to the network.' ,                                                                                      
       cdr_local_end_date string Comment 'The time in local time, that elapsed when the subscriber answered the call until the call was disconnected' ,                                                                                        
       cdr_cell_latitude string Comment 'Latitude of the Cell from the cellsector ref' ,                                                                                         
       cdr_cell_longitude string Comment 'Longitude of the Cell from the cellsector ref' ,                                                                                        
       cdr_imsi string Comment 'International Mobile Subscriber ID' ,                                                                                                  
       cdr_lsr_cell_distance_in_miles string Comment 'distance between cell co-ordinates,latitude and longitude' ,                                                                            
       cdr_lsr_cell_distance_in_miles_bucket string Comment 'Based on the distance between the cell co-ordinates, values are categorised into different buckets.Eg if distance in miles <=0.1 THEN 0 to 0.1' ,                                                                     
       cdr_lsr_delta_in_minutes string Comment 'time difference derived from the time to disconnect in cdr voice um and end time from traffic um' ,                                                                                  
       cdr_lsr_delta_in_minutes_bucket string Comment 'the cdr lsr time delta grouped into different buckets Eg delta_in_minutes <=0.1 then 0 to 0.1' ,                                                                           
       cdr_lsr_hexmarket string Comment 'Market name from cellsector ref table' ,                                                                                         
       cdr_lsr_hexregion string Comment 'region name from cellsector ref table' ,                                                                                         
       cdr_lsr_hexid Comment string 'hex id derived from the binning function hexencode  based on the cell latitude and longitude' ,                                                                                             
       cdr_lsr_hex_center_latitude string Comment 'latitude at the center of the bin derived using binning function hexencode' ,                                                                               
       cdr_lsr_hex_center_longitude string Comment 'longitude  at the center of the bin derived using binning function hexencode' ,                                                                              
       lsr_distance_in_miles string Comment 'derived from the LSR Traffice end location lat lon and cell latitude and longitude' ,                                                                                     
       lsr_distance_in_miles_bucket string Comment 'based on the distance in miles, values are categorised into different buckets.Eg - when distance_in_miles <=0.1 then 0 to 0.1' ,                                                                              
       lsr_imsi string Comment 'imsi from traffica um table' ,                                                                                                  
       lsr_start_mtmsi string Comment 'm-TMSI at RRC start from lsr traffica um' ,                                                                                           
       lsr_market string Comment 'market from traffica um table' ,                                                                                                
       lsr_last_cell_name string Comment 'last cellname from the lsr traffica um' ,                                                                                        
       lsr_cell_latitude string Comment 'Latitide for the Last cell from lsr_traffica um table' ,                                                                                         
       lsr_cell_longitude string Comment 'Longitude for the Last cell from lsr_traffica um table' ,                                                                                        
       lsr_user_latitude string Comment 'Latitide for the user from lsr_traffica um table that are close to the voice call' ,                                                                                         
       lsr_user_longitude string Comment 'Longitude for the user from lsr_traffica um table that are close to the voice call' ,                                                                                        
       lsr_local_end_date string Comment 'Timestamp for the user from lsr_traffica um table that are close to the voice call' ,                                                                                        
       lsr_rsrp string Comment 'RSRP in last RRC Measurement Report' ,                                                                                                  
       lsr_rsrq string Comment 'RSRQ in last RRC Measurement Report' ,                                                                                                  
       lsr_pucch_sinr string Comment 'PUCCH SINR at RRC Release' ,                                                                                            
       lsr_pusch_sinr string Comment 'PUSCH SINR at RRC Release' ,                                                                                            
       lsr_pucch_sinr_mw string Comment 'Power value of pucch_sinr' ,                                                                                         
       lsr_pusch_sinr_mw string Comment 'Power value of pusch_sinr' ,                                                                                         
       call_category string Comment 'Call category based on the MSISDNs from the RSpeed table (Internal_Test_MSISDN,Market_Test_MSISDN,Root_BAN_MSISDN)' ,                                                                                             
       customer_type  string Comment 'Customer type from BQR or NAP database' ,                                                                                             
       customer_brand string Comment 'Customer brand  from BQR or NAP database' ,                                                                                            
       data_bucket string Comment 'Data bucket  from BQR or NAP database' ,                                                                                               
       rrc_release_cause  string Comment 'RRC -Radio resource control  reason for radio connection release from the lsr_traffica_um table' ,                                                                                         
       s1_release_cause string Comment 'S1 reason for radio connection release from the lsr_traffica_um table' ,                                                                                          
       total_drops string Comment 'Total drops for the market' ,                                                                                               
       total_geo_drops string Comment 'Total drops thast are geolocated for the  market' ,                                                                                           
       geolocation_accuracy string Comment 'Percentage of the drops that are geolocated' ,                                                                                      
       cdr_cell_timezone string Comment 'Timezone for the CDR cells' ,                                                                                         
       mme_name string Comment 'Name of the mme node' ,                                                                                                  
       enb_tac string Comment 'Tracking area code for the LTE cells that are related to the voice calls' ,                                                                                                   
       ingestion_date string COMMENT 'The date on which the data was ingested',                                          
       added_by string COMMENT 'The ID of the user ,loading the data into the tables',                                   
       cdr_file_id string COMMENT 'The individual file identifier in the batch of source files',                         
       cdr_record_number string COMMENT 'The record number in the source File',                                          
       av_flag string Comment 'Flag that indicates the call type as Audio or Video' ,                                                                                                   
       lsr_uid string COMMENT 'Unique identifier for each LSR record,from lsr tables',                                   
       lsr_n1_rsrp_dbm int COMMENT 'RSRP for neighbor 1 in last RRC Measurement Report from lsr tables',                 
       lsr_n1_rsrq_db float COMMENT 'RSRQ for neighbor 1 in last RRC Measurement Report from lsr tables',                
       lsr_n2_rsrp_dbm int COMMENT 'RSRP for neighbor 2 in last RRC Measurement Report from lsr tables',                 
       lsr_n2_rsrq_db float COMMENT 'RSRQ for neighbor 2 in last RRC Measurement Report from lsr tables',                
       lsr_start_pci int COMMENT 'The PCI for RRC Start Cell,from lsr tables,from lsr tables',                           
       lsr_n1_pci int COMMENT 'PCI for neighbor 1 in last RRC Measurement Report,from lsr tables',                       
       lsr_n2_pci int COMMENT 'PCI for neighbor 2 in last RRC Measurement Report,from lsr tables',                       
       lsr_end_pci int COMMENT 'The PCI for end cell,from lsr tables',                                                   
       lsr_final_disposition string COMMENT 'Final RRC disposition determined from OEM Release Cause,from lsr tables',   
       lsr_last_ho_disposition string COMMENT 'The disposition of last handover,from lsr tables',                        
       lsr_mean_cqi float COMMENT 'Mean CQI in last eNB measurement report,from lsr tables',                             
       lsr_last_ho_source_cell string COMMENT 'The source Cell of last handover,from lsr tables',                        
       lsr_last_ho_target_cell string COMMENT 'The target Cell of last handover,from lsr tables',                        
       lsr_num_of_neighbors_count string COMMENT 'Number of neighbors,from lsr tables',                                  
       lsr_ue_power_headroom_db string COMMENT 'Power Headroom in db,from lsr tables',                                   
       lsr_handover_cause string COMMENT 'from lsr tables',                                                              
       lsr_ta_distance_meters string COMMENT 'from lsr tables',                                                          
       mcc string COMMENT 'The Mobile Country Code of this cell sector network',                                         
       mnc string COMMENT 'The Mobile network Code of this cell sector network',                                         
       cdr_last_cellname string Comment 'Last cellname' )                                                                                         
     PARTITIONED BY (                                                                                                      
       date_part string Comment 'Partition column' )                                                                                                 
    ;

    Hi Arthur,

    Here is the sql for your reference

Children
No Data