Hi @AnandVyas, My create table command works fine outside SAS and I can see data in my Hive table. However, I am not getting data from SAS. I turned on trace option. I am getting an output given below: 37 data mart.cars_test; 38 set sashelp.cars; 39 run; HADOOP_1: Prepared: on connection 1 SHOW TABLES IN `mart` 'CARS_TEST' NOTE: SAS variable labels, formats, and lengths are not written to DBMS tables. 2 The SAS System Thursday, 25 June 2020 18:57:00 HADOOP_2: Executed: on connection 2 CREATE TABLE `mart`.`CARS_TEST` (`Make` VARCHAR(13),`Model` VARCHAR(40),`Type` VARCHAR(8),`Origin` VARCHAR(6),`DriveTrain` VARCHAR(5),`MSRP` DOUBLE,`Invoice` DOUBLE,`EngineSize` DOUBLE,`Cylinders` DOUBLE,`Horsepower` DOUBLE,`MPG_City` DOUBLE,`MPG_Highway` DOUBLE,`Weight` DOUBLE,`Wheelbase` DOUBLE,`Length` DOUBLE) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\001' LINES TERMINATED BY '\012' STORED AS TEXTFILE TBLPROPERTIES ('SAS OS Name'='Linux','SAS Version'='9.04.01M6P11072018') NOTE: There were 428 observations read from the data set SASHELP.CARS. NOTE: The data set MART.CARS_TEST has 428 observations and 15 variables. HADOOP_3: Executed: on connection 2 LOAD DATA INPATH '/tmp/sasdata-xxxxx.dlv' OVERWRITE INTO TABLE `mart`.`CARS_TEST` NOTE: DATA statement used (Total process time): real time 4:04.02 cpu time 0.18 seconds 40 HADOOP_4: Prepared: on connection 0 DESCRIBE FORMATTED `mart`.`CARS_TEST` HADOOP_5: Prepared: on connection 0 SELECT * FROM `mart`.`CARS_TEST` LIMIT 0 -- /* initial prepare */ It looks fine from the output but still no luck. Do you have any idea? ... View more

Hi Amir,   Yes I ran all codes from top to bottom. Everything else works fine. I am getting the error when I run the mbaanalysis CAS action. ... View more