Hi there, While trying to MAP an Hbase locally created table in Phonenix via CREATE VIEW (Mapping to an Existing HBase Table) i am seeing strange and sort of corrupt data in the columns of following data types,
INTEGER BIGINT DECIMAL I can only see the correct data if i choose all the column mappings as VARCHAR in the view which is not acceptable as there could be DML operations (Like DELETE, UPDATES, SUM) needed as per data types on these fields, and semantically INTEGER data should be mapped as INTEGER rather than CHARCTERS. More problematic is that i am seeing strange data from this view in NUMBER datatypes but the INT data in Hbase has no issue like that, on one of the article on Google i found that it could be due to SERILIAZATION of the data while loading in Hbase. Data looks ok in Hbase but not when query in Phoenix https://groups.google.com/forum/#!topic/phoenix-hbase-user/wvgzItxliZs I used importtsv and completebulkload JARS for Hbase table data load, where do i can control the correct serialization of INTEGER data types while loading in Hbase with these loaders?, what could be the cause of that and how to fix it best? Best Regards, Ahmed.
