[ https://issues.apache.org/jira/browse/CARBONDATA-675?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15834433#comment-15834433 ]
Mohammad Shahid Khan commented on CARBONDATA-675: ------------------------------------------------- [~abhishekg] please make sure carbonplugin is present in /datadisk1/OSCON/BigData/HACluster/install/spark/sparkJdbc/ directory > DataLoad failure > ---------------- > > Key: CARBONDATA-675 > URL: https://issues.apache.org/jira/browse/CARBONDATA-675 > Project: CarbonData > Issue Type: Bug > Components: data-load, data-query > Environment: SPARK=1.6.2 > Reporter: abhishek giri > Priority: Critical > Attachments: dataload_default_failure.png, dataload_failure.png, > thriftlogs.txt > > > With performance test Create and Load this issue is coming.This issue is with > 300 column performance table. > System configuration :- RAM-30G ,Cores-16 > Command to start thrift :- ./bin/spark-submit --master yarn-client > --executor-memory 16g --executor-cores 8 --driver-memory 4g --num-executors 3 > --class org.apachecarbondata.spark.thriftserver.CarbonThriftServer <carbon > jar path> "hdfs://hacluster/Opt/CarbonStore" > Size of data :- 34.59034071 GB > Create query :- create table oscon_new_1 (ACTIVE_AREA_ID String, > ACTIVE_CHECK_DY String, ACTIVE_CHECK_HOUR String, ACTIVE_CHECK_MM String, > ACTIVE_CHECK_TIME String, ACTIVE_CHECK_YR String, ACTIVE_CITY String, > ACTIVE_COUNTRY String, ACTIVE_DISTRICT String, ACTIVE_EMUI_VERSION String, > ACTIVE_FIRMWARE_VER String, ACTIVE_NETWORK String, ACTIVE_OS_VERSION String, > ACTIVE_PROVINCE String, BOM String, CHECK_DATE String, CHECK_DY String, > CHECK_HOUR String, CHECK_MM String, CHECK_YR String, CUST_ADDRESS_ID String, > CUST_AGE String, CUST_BIRTH_COUNTRY String, CUST_BIRTH_DY String, > CUST_BIRTH_MM String, CUST_BIRTH_YR String, CUST_BUY_POTENTIAL String, > CUST_CITY String, CUST_STATE String, CUST_COUNTRY String, CUST_COUNTY String, > CUST_EMAIL_ADDR String, CUST_LAST_RVW_DATE timestamp, CUST_FIRST_NAME String, > CUST_ID String, CUST_JOB_TITLE String, CUST_LAST_NAME String, CUST_LOGIN > String, CUST_NICK_NAME String, CUST_PRFRD_FLG String, CUST_SEX String, > CUST_STREET_NAME String, CUST_STREET_NO String, CUST_SUITE_NO String, > CUST_ZIP String, DELIVERY_CITY String, DELIVERY_STATE String, > DELIVERY_COUNTRY String, DELIVERY_DISTRICT String, DELIVERY_PROVINCE String, > DEVICE_NAME String, INSIDE_NAME String, ITM_BRAND String, ITM_BRAND_ID > String, ITM_CATEGORY String, ITM_CATEGORY_ID String, ITM_CLASS String, > ITM_CLASS_ID String, ITM_COLOR String, ITM_CONTAINER String, ITM_FORMULATION > String, ITM_MANAGER_ID String, ITM_MANUFACT String, ITM_MANUFACT_ID String, > ITM_ID String, ITM_NAME String, ITM_REC_END_DATE String, ITM_REC_START_DATE > String, LATEST_AREAID String, LATEST_CHECK_DY String, LATEST_CHECK_HOUR > String, LATEST_CHECK_MM String, LATEST_CHECK_TIME String, LATEST_CHECK_YR > String, LATEST_CITY String, LATEST_COUNTRY String, LATEST_DISTRICT String, > LATEST_EMUI_VERSION String, LATEST_FIRMWARE_VER String, LATEST_NETWORK > String, LATEST_OS_VERSION String, LATEST_PROVINCE String, OL_ORDER_DATE > String, OL_ORDER_NO int, OL_RET_ORDER_NO String, OL_RET_DATE String, OL_SITE > String, OL_SITE_DESC String, PACKING_DATE String, PACKING_DY String, > PACKING_HOUR String, PACKING_LIST_NO String, PACKING_MM String, PACKING_YR > String, PRMTION_ID String, PRMTION_NAME String, PRM_CHANNEL_CAT String, > PRM_CHANNEL_DEMO String, PRM_CHANNEL_DETAILS String, PRM_CHANNEL_DMAIL > String, PRM_CHANNEL_EMAIL String, PRM_CHANNEL_EVENT String, PRM_CHANNEL_PRESS > String, PRM_CHANNEL_RADIO String, PRM_CHANNEL_TV String, PRM_DSCNT_ACTIVE > String, PRM_END_DATE String, PRM_PURPOSE String, PRM_START_DATE String, > PRODUCT_ID String, PROD_BAR_CODE String, PROD_BRAND_NAME String, PRODUCT_NAME > String, PRODUCT_MODEL String, PROD_MODEL_ID String, PROD_COLOR String, > PROD_SHELL_COLOR String, PROD_CPU_CLOCK String, PROD_IMAGE String, PROD_LIVE > String, PROD_LOC String, PROD_LONG_DESC String, PROD_RAM String, PROD_ROM > String, PROD_SERIES String, PROD_SHORT_DESC String, PROD_THUMB String, > PROD_UNQ_DEVICE_ADDR String, PROD_UNQ_MDL_ID String, PROD_UPDATE_DATE String, > PROD_UQ_UUID String, SHP_CARRIER String, SHP_CODE String, SHP_CONTRACT > String, SHP_MODE_ID String, SHP_MODE String, STR_ORDER_DATE String, > STR_ORDER_NO String, TRACKING_NO String, WH_CITY String, WH_COUNTRY String, > WH_COUNTY String, WH_ID String, WH_NAME String, WH_STATE String, > WH_STREET_NAME String, WH_STREET_NO String, WH_STREET_TYPE String, > WH_SUITE_NO String, WH_ZIP String, CUST_DEP_COUNT double, CUST_VEHICLE_COUNT > double, CUST_ADDRESS_CNT double, CUST_CRNT_CDEMO_CNT double, > CUST_CRNT_HDEMO_CNT double, CUST_CRNT_ADDR_DM double, CUST_FIRST_SHIPTO_CNT > double, CUST_FIRST_SALES_CNT double, CUST_GMT_OFFSET double, CUST_DEMO_CNT > double, CUST_INCOME double, PROD_UNLIMITED int, PROD_OFF_PRICE double, > PROD_UNITS int, TOTAL_PRD_COST double, TOTAL_PRD_DISC double, PROD_WEIGHT > double, REG_UNIT_PRICE double, EXTENDED_AMT double, UNIT_PRICE_DSCNT_PCT > double, DSCNT_AMT double, PROD_STD_CST double, TOTAL_TX_AMT double, > FREIGHT_CHRG double, WAITING_PERIOD double, DELIVERY_PERIOD double, > ITM_CRNT_PRICE double, ITM_UNITS double, ITM_WSLE_CST double, ITM_SIZE > double, PRM_CST double, PRM_RESPONSE_TARGET double, PRM_ITM_DM double, > SHP_MODE_CNT double, WH_GMT_OFFSET double, WH_SQ_FT double, STR_ORD_QTY > double, STR_WSLE_CST double, STR_LIST_PRICE double, STR_SALES_PRICE double, > STR_EXT_DSCNT_AMT double, STR_EXT_SALES_PRICE double, STR_EXT_WSLE_CST > double, STR_EXT_LIST_PRICE double, STR_EXT_TX double, STR_COUPON_AMT double, > STR_NET_PAID double, STR_NET_PAID_INC_TX double, STR_NET_PRFT double, > STR_SOLD_YR_CNT double, STR_SOLD_MM_CNT double, STR_SOLD_ITM_CNT double, > STR_TOTAL_CUST_CNT double, STR_AREA_CNT double, STR_DEMO_CNT double, > STR_OFFER_CNT double, STR_PRM_CNT double, STR_TICKET_CNT double, > STR_NET_PRFT_DM_A double, STR_NET_PRFT_DM_B double, STR_NET_PRFT_DM_C double, > STR_NET_PRFT_DM_D double, STR_NET_PRFT_DM_E double, STR_RET_STR_ID double, > STR_RET_REASON_CNT double, STR_RET_TICKET_NO double, STR_RTRN_QTY double, > STR_RTRN_AMT double, STR_RTRN_TX double, STR_RTRN_AMT_INC_TX double, > STR_RET_FEE double, STR_RTRN_SHIP_CST double, STR_RFNDD_CSH double, > STR_REVERSED_CHRG double, STR_STR_CREDIT double, STR_RET_NET_LOSS double, > STR_RTRNED_YR_CNT double, STR_RTRN_MM_CNT double, STR_RET_ITM_CNT double, > STR_RET_CUST_CNT double, STR_RET_AREA_CNT double, STR_RET_OFFER_CNT double, > STR_RET_PRM_CNT double, STR_RET_NET_LOSS_DM_A double, STR_RET_NET_LOSS_DM_B > double, STR_RET_NET_LOSS_DM_C double, STR_RET_NET_LOSS_DM_D double, > OL_ORD_QTY double, OL_WSLE_CST double, OL_LIST_PRICE double, OL_SALES_PRICE > double, OL_EXT_DSCNT_AMT double, OL_EXT_SALES_PRICE double, OL_EXT_WSLE_CST > double, OL_EXT_LIST_PRICE double, OL_EXT_TX double, OL_COUPON_AMT double, > OL_EXT_SHIP_CST double, OL_NET_PAID double, OL_NET_PAID_INC_TX double, > OL_NET_PAID_INC_SHIP double, OL_NET_PAID_INC_SHIP_TX double, OL_NET_PRFT > double, OL_SOLD_YR_CNT double, OL_SOLD_MM_CNT double, OL_SHIP_DATE_CNT > double, OL_ITM_CNT double, OL_BILL_CUST_CNT double, OL_BILL_AREA_CNT double, > OL_BILL_DEMO_CNT double, OL_BILL_OFFER_CNT double, OL_SHIP_CUST_CNT double, > OL_SHIP_AREA_CNT double, OL_SHIP_DEMO_CNT double, OL_SHIP_OFFER_CNT double, > OL_WEB_PAGE_CNT double, OL_WEB_SITE_CNT double, OL_SHIP_MODE_CNT double, > OL_WH_CNT double, OL_PRM_CNT double, OL_NET_PRFT_DM_A double, > OL_NET_PRFT_DM_B double, OL_NET_PRFT_DM_C double, OL_NET_PRFT_DM_D double, > OL_RET_RTRN_QTY double, OL_RTRN_AMT double, OL_RTRN_TX double, > OL_RTRN_AMT_INC_TX double, OL_RET_FEE double, OL_RTRN_SHIP_CST double, > OL_RFNDD_CSH double, OL_REVERSED_CHRG double, OL_ACCOUNT_CREDIT double, > OL_RTRNED_YR_CNT double, OL_RTRNED_MM_CNT double, OL_RTRITM_CNT double, > OL_RFNDD_CUST_CNT double, OL_RFNDD_AREA_CNT double, OL_RFNDD_DEMO_CNT double, > OL_RFNDD_OFFER_CNT double, OL_RTRNING_CUST_CNT double, OL_RTRNING_AREA_CNT > double, OL_RTRNING_DEMO_CNT double, OL_RTRNING_OFFER_CNT double, > OL_RTRWEB_PAGE_CNT double, OL_REASON_CNT double, OL_NET_LOSS double, > OL_NET_LOSS_DM_A double, OL_NET_LOSS_DM_B double, OL_NET_LOSS_DM_C double) > STORED BY 'org.apache.carbondata.format'; > Load Query :- load data inpath > 'hdfs://hacluster/benchmarks/CarbonData/data/datafile_0.csv' into table > oscon_VIP options('DELIMITER'=',', > 'QUOTECHAR'='"','FILEHEADER'='ACTIVE_AREA_ID, ACTIVE_CHECK_DY, > ACTIVE_CHECK_HOUR, ACTIVE_CHECK_MM, ACTIVE_CHECK_TIME, ACTIVE_CHECK_YR, > ACTIVE_CITY, ACTIVE_COUNTRY, ACTIVE_DISTRICT, ACTIVE_EMUI_VERSION, > ACTIVE_FIRMWARE_VER, ACTIVE_NETWORK, ACTIVE_OS_VERSION, ACTIVE_PROVINCE, BOM, > CHECK_DATE, CHECK_DY, CHECK_HOUR, CHECK_MM, CHECK_YR, CUST_ADDRESS_ID, > CUST_AGE, CUST_BIRTH_COUNTRY, CUST_BIRTH_DY, CUST_BIRTH_MM, CUST_BIRTH_YR, > CUST_BUY_POTENTIAL, CUST_CITY, CUST_STATE, CUST_COUNTRY, CUST_COUNTY, > CUST_EMAIL_ADDR, CUST_LAST_RVW_DATE, CUST_FIRST_NAME, CUST_ID, > CUST_JOB_TITLE, CUST_LAST_NAME, CUST_LOGIN, CUST_NICK_NAME, CUST_PRFRD_FLG, > CUST_SEX, CUST_STREET_NAME, CUST_STREET_NO, CUST_SUITE_NO, CUST_ZIP, > DELIVERY_CITY, DELIVERY_STATE, DELIVERY_COUNTRY, DELIVERY_DISTRICT, > DELIVERY_PROVINCE, DEVICE_NAME, INSIDE_NAME, ITM_BRAND, ITM_BRAND_ID, > ITM_CATEGORY, ITM_CATEGORY_ID, ITM_CLASS, ITM_CLASS_ID, ITM_COLOR, > ITM_CONTAINER, ITM_FORMULATION, ITM_MANAGER_ID, ITM_MANUFACT, > ITM_MANUFACT_ID, ITM_ID, ITM_NAME, ITM_REC_END_DATE, ITM_REC_START_DATE, > LATEST_AREAID, LATEST_CHECK_DY, LATEST_CHECK_HOUR, LATEST_CHECK_MM, > LATEST_CHECK_TIME, LATEST_CHECK_YR, LATEST_CITY, LATEST_COUNTRY, > LATEST_DISTRICT, LATEST_EMUI_VERSION, LATEST_FIRMWARE_VER, LATEST_NETWORK, > LATEST_OS_VERSION, LATEST_PROVINCE, OL_ORDER_DATE, OL_ORDER_NO, > OL_RET_ORDER_NO, OL_RET_DATE, OL_SITE, OL_SITE_DESC, PACKING_DATE, > PACKING_DY, PACKING_HOUR, PACKING_LIST_NO, PACKING_MM, PACKING_YR, > PRMTION_ID, PRMTION_NAME, PRM_CHANNEL_CAT, PRM_CHANNEL_DEMO, > PRM_CHANNEL_DETAILS, PRM_CHANNEL_DMAIL, PRM_CHANNEL_EMAIL, PRM_CHANNEL_EVENT, > PRM_CHANNEL_PRESS, PRM_CHANNEL_RADIO, PRM_CHANNEL_TV, PRM_DSCNT_ACTIVE, > PRM_END_DATE, PRM_PURPOSE, PRM_START_DATE, PRODUCT_ID, PROD_BAR_CODE, > PROD_BRAND_NAME, PRODUCT_NAME, PRODUCT_MODEL, PROD_MODEL_ID, PROD_COLOR, > PROD_SHELL_COLOR, PROD_CPU_CLOCK, PROD_IMAGE, PROD_LIVE, PROD_LOC, > PROD_LONG_DESC, PROD_RAM, PROD_ROM, PROD_SERIES, PROD_SHORT_DESC, PROD_THUMB, > PROD_UNQ_DEVICE_ADDR, PROD_UNQ_MDL_ID, PROD_UPDATE_DATE, PROD_UQ_UUID, > SHP_CARRIER, SHP_CODE, SHP_CONTRACT, SHP_MODE_ID, SHP_MODE, STR_ORDER_DATE, > STR_ORDER_NO, TRACKING_NO, WH_CITY, WH_COUNTRY, WH_COUNTY, WH_ID, WH_NAME, > WH_STATE, WH_STREET_NAME, WH_STREET_NO, WH_STREET_TYPE, WH_SUITE_NO, WH_ZIP, > CUST_DEP_COUNT, CUST_VEHICLE_COUNT, CUST_ADDRESS_CNT, CUST_CRNT_CDEMO_CNT, > CUST_CRNT_HDEMO_CNT, CUST_CRNT_ADDR_DM, CUST_FIRST_SHIPTO_CNT, > CUST_FIRST_SALES_CNT, CUST_GMT_OFFSET, CUST_DEMO_CNT, CUST_INCOME, > PROD_UNLIMITED, PROD_OFF_PRICE, PROD_UNITS, TOTAL_PRD_COST, TOTAL_PRD_DISC, > PROD_WEIGHT, REG_UNIT_PRICE, EXTENDED_AMT, UNIT_PRICE_DSCNT_PCT, DSCNT_AMT, > PROD_STD_CST, TOTAL_TX_AMT, FREIGHT_CHRG, WAITING_PERIOD, DELIVERY_PERIOD, > ITM_CRNT_PRICE, ITM_UNITS, ITM_WSLE_CST, ITM_SIZE, PRM_CST, > PRM_RESPONSE_TARGET, PRM_ITM_DM, SHP_MODE_CNT, WH_GMT_OFFSET, WH_SQ_FT, > STR_ORD_QTY, STR_WSLE_CST, STR_LIST_PRICE, STR_SALES_PRICE, > STR_EXT_DSCNT_AMT, STR_EXT_SALES_PRICE, STR_EXT_WSLE_CST, STR_EXT_LIST_PRICE, > STR_EXT_TX, STR_COUPON_AMT, STR_NET_PAID, STR_NET_PAID_INC_TX, STR_NET_PRFT, > STR_SOLD_YR_CNT, STR_SOLD_MM_CNT, STR_SOLD_ITM_CNT, STR_TOTAL_CUST_CNT, > STR_AREA_CNT, STR_DEMO_CNT, STR_OFFER_CNT, STR_PRM_CNT, STR_TICKET_CNT, > STR_NET_PRFT_DM_A, STR_NET_PRFT_DM_B, STR_NET_PRFT_DM_C, STR_NET_PRFT_DM_D, > STR_NET_PRFT_DM_E, STR_RET_STR_ID, STR_RET_REASON_CNT, STR_RET_TICKET_NO, > STR_RTRN_QTY, STR_RTRN_AMT, STR_RTRN_TX, STR_RTRN_AMT_INC_TX, STR_RET_FEE, > STR_RTRN_SHIP_CST, STR_RFNDD_CSH, STR_REVERSED_CHRG, STR_STR_CREDIT, > STR_RET_NET_LOSS, STR_RTRNED_YR_CNT, STR_RTRN_MM_CNT, STR_RET_ITM_CNT, > STR_RET_CUST_CNT, STR_RET_AREA_CNT, STR_RET_OFFER_CNT, STR_RET_PRM_CNT, > STR_RET_NET_LOSS_DM_A, STR_RET_NET_LOSS_DM_B, STR_RET_NET_LOSS_DM_C, > STR_RET_NET_LOSS_DM_D, OL_ORD_QTY, OL_WSLE_CST, OL_LIST_PRICE, > OL_SALES_PRICE, OL_EXT_DSCNT_AMT, OL_EXT_SALES_PRICE, OL_EXT_WSLE_CST, > OL_EXT_LIST_PRICE, OL_EXT_TX, OL_COUPON_AMT, OL_EXT_SHIP_CST, OL_NET_PAID, > OL_NET_PAID_INC_TX, OL_NET_PAID_INC_SHIP, OL_NET_PAID_INC_SHIP_TX, > OL_NET_PRFT, OL_SOLD_YR_CNT, OL_SOLD_MM_CNT, OL_SHIP_DATE_CNT, OL_ITM_CNT, > OL_BILL_CUST_CNT, OL_BILL_AREA_CNT, OL_BILL_DEMO_CNT, OL_BILL_OFFER_CNT, > OL_SHIP_CUST_CNT, OL_SHIP_AREA_CNT, OL_SHIP_DEMO_CNT, OL_SHIP_OFFER_CNT, > OL_WEB_PAGE_CNT, OL_WEB_SITE_CNT, OL_SHIP_MODE_CNT, OL_WH_CNT, OL_PRM_CNT, > OL_NET_PRFT_DM_A, OL_NET_PRFT_DM_B, OL_NET_PRFT_DM_C, OL_NET_PRFT_DM_D, > OL_RET_RTRN_QTY, OL_RTRN_AMT, OL_RTRN_TX, OL_RTRN_AMT_INC_TX, OL_RET_FEE, > OL_RTRN_SHIP_CST, OL_RFNDD_CSH, OL_REVERSED_CHRG, OL_ACCOUNT_CREDIT, > OL_RTRNED_YR_CNT, OL_RTRNED_MM_CNT, OL_RTRITM_CNT, OL_RFNDD_CUST_CNT, > OL_RFNDD_AREA_CNT, OL_RFNDD_DEMO_CNT, OL_RFNDD_OFFER_CNT, > OL_RTRNING_CUST_CNT, OL_RTRNING_AREA_CNT, OL_RTRNING_DEMO_CNT, > OL_RTRNING_OFFER_CNT, OL_RTRWEB_PAGE_CNT, OL_REASON_CNT, OL_NET_LOSS, > OL_NET_LOSS_DM_A, OL_NET_LOSS_DM_B, > OL_NET_LOSS_DM_C','BAD_RECORDS_ACTION'='FORCE','BAD_RECORDS_LOGGER_ENABLE'='FALSE'); -- This message was sent by Atlassian JIRA (v6.3.4#6332)