phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From vikashtalanki <vikashtala...@gmail.com>
Subject Re: ERROR 201 (22000) illegal data error, expected length at least 4 but had ...
Date Fri, 12 Aug 2016 06:24:03 GMT
Hi Dong,

If you still want to insert through hbase, you can use the below snippets
for encoding values as per phoenix. ---> import
org.apache.phoenix.schema.types.*;

public static byte[] encodeDecimal(String value)
	{
		BigDecimal bigDecValue = new BigDecimal(value);
		byte[] pDecimalByteArray = PDecimal.INSTANCE.toBytes(bigDecValue);
		return pDecimalByteArray;
	}
	
	public static byte[] encodeDate(java.util.Date utilDate)
	{
		java.sql.Date sqlDate = new Date(utilDate.getTime());
		byte[] pDateByteArray = PDate.INSTANCE.toBytes(sqlDate);
		return pDateByteArray;
	}
	
	public static byte[] encodeTimestamp(String utilTS)
	{
		java.sql.Timestamp sqlDate = Timestamp.valueOf(utilTS);
		byte[] pTSByteArray = PTimestamp.INSTANCE.toBytes(sqlDate);
		return pTSByteArray;
	}
	
	public static byte[] encodeLong(String value)
	{
		byte[] pLongByteArray = PLong.INSTANCE.toBytes(value);
		return pLongByteArray;
	}
	
	public static byte[] encodeChar(String value)
	{
		byte[] pCharByteArray = PChar.INSTANCE.toBytes(value);
		return pCharByteArray;
	}
	
	public static byte[] encodeVarchar(String value)
	{
		byte[] pVarcharByteArray = PVarchar.INSTANCE.toBytes(value);
		return pVarcharByteArray;
	}
	
	public static byte[] encodeShort(String value)
	{
		Short shortValue = Short.parseShort(value);
		byte[] pShortByteArray = PSmallint.INSTANCE.toBytes(shortValue);
		return pShortByteArray;
	}
	
	public static byte[] encodeInteger(String value)
	{
		int intValue = Integer.parseInt(value);
		byte[] pIntByteArray = PInteger.INSTANCE.toBytes(intValue);
		return pIntByteArray;
	} 



--
View this message in context: http://apache-phoenix-user-list.1124778.n5.nabble.com/ERROR-201-22000-illegal-data-error-expected-length-at-least-4-but-had-tp2170p2202.html
Sent from the Apache Phoenix User List mailing list archive at Nabble.com.

Mime
View raw message