[jira] [Assigned] (CARBONDATA-696) NPE when select query run on measure having double data type without fraction.
[
https://issues.apache.org/jira/browse/CARBONDATA-696?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kunal Kapoor reassigned CARBONDATA-696:
---
Assignee: Kunal Kapoor (was: kumar vishal)
> NPE when select query run on measure having double data type without
> fraction.
> ---
>
> Key: CARBONDATA-696
> URL: https://issues.apache.org/jira/browse/CARBONDATA-696
> Project: CarbonData
> Issue Type: Bug
> Components: data-query
>Affects Versions: 1.0.0-incubating
>Reporter: Babulal
>Assignee: Kunal Kapoor
> Attachments: logs, oscon_10.csv
>
>
> Create table as below
> cc.sql("create table oscon_carbon_old (CUST_PRFRD_FLG String,PROD_BRAND_NAME
> String,PROD_COLOR String,CUST_LAST_RVW_DATE String,CUST_COUNTRY
> String,CUST_CITY String,PRODUCT_NAME String,CUST_JOB_TITLE String,CUST_STATE
> String,CUST_BUY_POTENTIAL String,PRODUCT_MODEL String,ITM_ID String,ITM_NAME
> String,PRMTION_ID String,PRMTION_NAME String,SHP_MODE_ID String,SHP_MODE
> String,DELIVERY_COUNTRY String,DELIVERY_STATE String,DELIVERY_CITY
> String,DELIVERY_DISTRICT String,ACTIVE_EMUI_VERSION String,WH_NAME
> String,STR_ORDER_DATE String,OL_ORDER_NO String,OL_ORDER_DATE String,OL_SITE
> String,CUST_FIRST_NAME String,CUST_LAST_NAME String,CUST_BIRTH_DY
> String,CUST_BIRTH_MM String,CUST_BIRTH_YR String,CUST_BIRTH_COUNTRY
> String,CUST_SEX String,CUST_ADDRESS_ID String,CUST_STREET_NO
> String,CUST_STREET_NAME String,CUST_AGE String,CUST_SUITE_NO String,CUST_ZIP
> String,CUST_COUNTY String,PRODUCT_ID String,PROD_SHELL_COLOR
> String,DEVICE_NAME String,PROD_SHORT_DESC String,PROD_LONG_DESC
> String,PROD_THUMB String,PROD_IMAGE String,PROD_UPDATE_DATE String,PROD_LIVE
> String,PROD_LOC String,PROD_RAM String,PROD_ROM String,PROD_CPU_CLOCK
> String,PROD_SERIES String,ITM_REC_START_DATE String,ITM_REC_END_DATE
> String,ITM_BRAND_ID String,ITM_BRAND String,ITM_CLASS_ID String,ITM_CLASS
> String,ITM_CATEGORY_ID String,ITM_CATEGORY String,ITM_MANUFACT_ID
> String,ITM_MANUFACT String,ITM_FORMULATION String,ITM_COLOR
> String,ITM_CONTAINER String,ITM_MANAGER_ID String,PRM_START_DATE
> String,PRM_END_DATE String,PRM_CHANNEL_DMAIL String,PRM_CHANNEL_EMAIL
> String,PRM_CHANNEL_CAT String,PRM_CHANNEL_TV String,PRM_CHANNEL_RADIO
> String,PRM_CHANNEL_PRESS String,PRM_CHANNEL_EVENT String,PRM_CHANNEL_DEMO
> String,PRM_CHANNEL_DETAILS String,PRM_PURPOSE String,PRM_DSCNT_ACTIVE
> String,SHP_CODE String,SHP_CARRIER String,SHP_CONTRACT String,CHECK_DATE
> String,CHECK_YR String,CHECK_MM String,CHECK_DY String,CHECK_HOUR String,BOM
> String,INSIDE_NAME String,PACKING_DATE String,PACKING_YR String,PACKING_MM
> String,PACKING_DY String,PACKING_HOUR String,DELIVERY_PROVINCE
> String,PACKING_LIST_NO String,ACTIVE_CHECK_TIME String,ACTIVE_CHECK_YR
> String,ACTIVE_CHECK_MM String,ACTIVE_CHECK_DY String,ACTIVE_CHECK_HOUR
> String,ACTIVE_AREA_ID String,ACTIVE_COUNTRY String,ACTIVE_PROVINCE
> String,ACTIVE_CITY String,ACTIVE_DISTRICT String,ACTIVE_NETWORK
> String,ACTIVE_FIRMWARE_VER String,ACTIVE_OS_VERSION String,LATEST_CHECK_TIME
> String,LATEST_CHECK_YR String,LATEST_CHECK_MM String,LATEST_CHECK_DY
> String,LATEST_CHECK_HOUR String,LATEST_AREAID String,LATEST_COUNTRY
> String,LATEST_PROVINCE String,LATEST_CITY String,LATEST_DISTRICT
> String,LATEST_FIRMWARE_VER String,LATEST_EMUI_VERSION
> String,LATEST_OS_VERSION String,LATEST_NETWORK String,WH_ID
> String,WH_STREET_NO String,WH_STREET_NAME String,WH_STREET_TYPE
> String,WH_SUITE_NO String,WH_CITY String,WH_COUNTY String,WH_STATE
> String,WH_ZIP String,WH_COUNTRY String,OL_SITE_DESC String,OL_RET_ORDER_NO
> String,OL_RET_DATE String,PROD_MODEL_ID String,CUST_ID String,PROD_UNQ_MDL_ID
> String,CUST_NICK_NAME String,CUST_LOGIN String,CUST_EMAIL_ADDR
> String,PROD_UNQ_DEVICE_ADDR String,PROD_UQ_UUID String,PROD_BAR_CODE
> String,TRACKING_NO String,STR_ORDER_NO 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 double,PROD_OFF_PRICE double,PROD_UNITS
> double,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
[jira] [Assigned] (CARBONDATA-696) NPE when select query run on measure having double data type without fraction.
[
https://issues.apache.org/jira/browse/CARBONDATA-696?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
kumar vishal reassigned CARBONDATA-696:
---
Assignee: kumar vishal
> NPE when select query run on measure having double data type without
> fraction.
> ---
>
> Key: CARBONDATA-696
> URL: https://issues.apache.org/jira/browse/CARBONDATA-696
> Project: CarbonData
> Issue Type: Bug
> Components: data-query
>Affects Versions: 1.0.0-incubating
>Reporter: Babulal
>Assignee: kumar vishal
> Attachments: logs, oscon_10.csv
>
>
> Create table as below
> cc.sql("create table oscon_carbon_old (CUST_PRFRD_FLG String,PROD_BRAND_NAME
> String,PROD_COLOR String,CUST_LAST_RVW_DATE String,CUST_COUNTRY
> String,CUST_CITY String,PRODUCT_NAME String,CUST_JOB_TITLE String,CUST_STATE
> String,CUST_BUY_POTENTIAL String,PRODUCT_MODEL String,ITM_ID String,ITM_NAME
> String,PRMTION_ID String,PRMTION_NAME String,SHP_MODE_ID String,SHP_MODE
> String,DELIVERY_COUNTRY String,DELIVERY_STATE String,DELIVERY_CITY
> String,DELIVERY_DISTRICT String,ACTIVE_EMUI_VERSION String,WH_NAME
> String,STR_ORDER_DATE String,OL_ORDER_NO String,OL_ORDER_DATE String,OL_SITE
> String,CUST_FIRST_NAME String,CUST_LAST_NAME String,CUST_BIRTH_DY
> String,CUST_BIRTH_MM String,CUST_BIRTH_YR String,CUST_BIRTH_COUNTRY
> String,CUST_SEX String,CUST_ADDRESS_ID String,CUST_STREET_NO
> String,CUST_STREET_NAME String,CUST_AGE String,CUST_SUITE_NO String,CUST_ZIP
> String,CUST_COUNTY String,PRODUCT_ID String,PROD_SHELL_COLOR
> String,DEVICE_NAME String,PROD_SHORT_DESC String,PROD_LONG_DESC
> String,PROD_THUMB String,PROD_IMAGE String,PROD_UPDATE_DATE String,PROD_LIVE
> String,PROD_LOC String,PROD_RAM String,PROD_ROM String,PROD_CPU_CLOCK
> String,PROD_SERIES String,ITM_REC_START_DATE String,ITM_REC_END_DATE
> String,ITM_BRAND_ID String,ITM_BRAND String,ITM_CLASS_ID String,ITM_CLASS
> String,ITM_CATEGORY_ID String,ITM_CATEGORY String,ITM_MANUFACT_ID
> String,ITM_MANUFACT String,ITM_FORMULATION String,ITM_COLOR
> String,ITM_CONTAINER String,ITM_MANAGER_ID String,PRM_START_DATE
> String,PRM_END_DATE String,PRM_CHANNEL_DMAIL String,PRM_CHANNEL_EMAIL
> String,PRM_CHANNEL_CAT String,PRM_CHANNEL_TV String,PRM_CHANNEL_RADIO
> String,PRM_CHANNEL_PRESS String,PRM_CHANNEL_EVENT String,PRM_CHANNEL_DEMO
> String,PRM_CHANNEL_DETAILS String,PRM_PURPOSE String,PRM_DSCNT_ACTIVE
> String,SHP_CODE String,SHP_CARRIER String,SHP_CONTRACT String,CHECK_DATE
> String,CHECK_YR String,CHECK_MM String,CHECK_DY String,CHECK_HOUR String,BOM
> String,INSIDE_NAME String,PACKING_DATE String,PACKING_YR String,PACKING_MM
> String,PACKING_DY String,PACKING_HOUR String,DELIVERY_PROVINCE
> String,PACKING_LIST_NO String,ACTIVE_CHECK_TIME String,ACTIVE_CHECK_YR
> String,ACTIVE_CHECK_MM String,ACTIVE_CHECK_DY String,ACTIVE_CHECK_HOUR
> String,ACTIVE_AREA_ID String,ACTIVE_COUNTRY String,ACTIVE_PROVINCE
> String,ACTIVE_CITY String,ACTIVE_DISTRICT String,ACTIVE_NETWORK
> String,ACTIVE_FIRMWARE_VER String,ACTIVE_OS_VERSION String,LATEST_CHECK_TIME
> String,LATEST_CHECK_YR String,LATEST_CHECK_MM String,LATEST_CHECK_DY
> String,LATEST_CHECK_HOUR String,LATEST_AREAID String,LATEST_COUNTRY
> String,LATEST_PROVINCE String,LATEST_CITY String,LATEST_DISTRICT
> String,LATEST_FIRMWARE_VER String,LATEST_EMUI_VERSION
> String,LATEST_OS_VERSION String,LATEST_NETWORK String,WH_ID
> String,WH_STREET_NO String,WH_STREET_NAME String,WH_STREET_TYPE
> String,WH_SUITE_NO String,WH_CITY String,WH_COUNTY String,WH_STATE
> String,WH_ZIP String,WH_COUNTRY String,OL_SITE_DESC String,OL_RET_ORDER_NO
> String,OL_RET_DATE String,PROD_MODEL_ID String,CUST_ID String,PROD_UNQ_MDL_ID
> String,CUST_NICK_NAME String,CUST_LOGIN String,CUST_EMAIL_ADDR
> String,PROD_UNQ_DEVICE_ADDR String,PROD_UQ_UUID String,PROD_BAR_CODE
> String,TRACKING_NO String,STR_ORDER_NO 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 double,PROD_OFF_PRICE double,PROD_UNITS
> double,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
