Phoenix odbc is truncating column data. I have one column with csv data in it. How can we increase the size of the column in odbc?

chaitany84 · ‎04-20-2017

chaitany84 · ‎04-20-2017

Here is my data...

f5859653164f2e80688031b853bd9912 | f5859653164f2e80688031b853bd9912,KSC029,C,KS,CLOUD COUNTY,JAMESTOWN,SE,2017-04-19T17:35:00,CDT,America

In tableau i see this..

f5859653164f2e80688031b853bd9912,KSC029,

elserj · ‎04-20-2017

Please provide some more context about what's going on. To the best of my knowledge, the Phoenix ODBC does not truncate any data as you assume.

Share your table DDL and a DML statement which triggers this issue (preferably a DML statement which doesn't include any sensitive data..)

chaitany84 · ‎04-20-2017

ALLOWHOSTNAMECNMISMATCH=0;ALLOWSELFSIGNEDSERVERCERT=0;AUTHMECH=0;BINARYPARAMETERLENGTH=1024;CONNECTIONSYNCINTERVAL=300;DECIMALPARAMETERPRECISION=38;DECIMALPARAMETERSCALE=15;DESCRIPTION=;ENABLEDOUBLEBUFFER=1;HOST=xxxx;HTTPPATH=;LNG=;ROWSFETCHPERBLOCK=10000;SSL=0;TRUSTEDCERTS=C:\Program Files\Hortonworks Phoenix ODBC Driver\lib\cacerts.pem;USEUNICODESQLCHARACTERTYPES=0

Do i need to change any of these settings? I can view the data in phoenix

Phoenix Schema

stormreportscountrywide | PK | 12 | V |

stormreportscountrywide | csv | 12 | V |

Data

fd65c268f7b26c471f8df2d0dfc22e2e | fd65c268f7b26c471f8df2d0dfc22e2e,TNC037,C,TN,DAVIDSON COUNTY,NASHVILLE,SE,2017-04-18T19:30:00,CDT,America/Chicago,1492561800,36.17,-86.78,KOHX,,,,FLOODING,FLD,FLASH FLOOD,FL | | fe4e924bf505b436e0d900e6117e27a1 | fe4e924bf505b436e0d900e6117e27a1,SDC081,C,SD,LAWRENCE COUNTY,5 MILES WEST OF DOWNTOWN SPEARFISH,WE,2017-04-17T20:28:00,MDT,America/Denver,1492482480,44.5,-103.96,KUNR,63,M,M | | fe6b83e9de0440e34d3e2dec46b49dde | fe6b83e9de0440e34d3e2dec46b49dde,TXC039,C,TX,BRAZORIA COUNTY,DANBURY,SE,2017-04-18T05:35:00,CDT,America/Chicago,1492511700,29.23,-95.35,KHGX,,,,FLOODING,FLD,FLASH FLOOD,FLA, | | fe79a6c2f53245dc6efb5aec5a18be51 | fe79a6c2f53245dc6efb5aec5a18be51,INC033,C,IN,DEKALB COUNTY,SPENCERVILLE,MW,2017-04-19T20:17:00,EDT,America/New_York,1492647420,41.28,-84.92,KIWX,1.25,E,INCHES,SEVERE,SVR,HAI | | fe88ee7fb2d3d029506e31535d09bf9a | fe88ee7fb2d3d029506e31535d09bf9a,NYC095,C,NY,SCHOHARIE COUNTY,JEFFERSON,NE,2017-04-19T17:20:00,EDT,America/New_York,1492636800,42.48,-74.61,KALY,0.25,M,INCHES,RAINFALL,RAI,S | | ff6afeca56e98b3ac98340b16c67b20b | ff6afeca56e98b3ac98340b16c67b20b,NYC013,C,NY,CHAUTAUQUA COUNTY,JAMESTOWN AIRPORT,NE,2017-04-20T07:55:00,EDT,America/New_York,1492689300,42.15333,-79.25778,KBUF,0.75,M,INCHES |

HBase

'stormreportscountrywide', {TABLE_ATTRIBUTES => {coprocessor$1 => '|org.apache.phoenix.coprocessor.ScanRegionObserver|805306366|', coprocessor$2 => '|org.apache.phoenix.coprocessor.UngroupedAggregateRegionObserver|805306366|', coprocessor$3 => '|org.apache.phoenix.coprocessor.GroupedAggregateRegionObserver|805306366|', coprocessor$4 => '|org.apache.phoenix.coprocessor.ServerCachingEndpointImpl|805306366|'}, {NAME => 'wd'}