phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dong-iL, Kim" <kim.s...@gmail.com>
Subject Re: ERROR 201 (22000) illegal data error, expected length at least 4 but had ...
Date Fri, 12 Aug 2016 12:16:21 GMT
Oh. Thanks a lot.

do you have a snippet for generating composite key?

I’m sorry for my laziness. 


> On Aug 12, 2016, at 3:24 PM, vikashtalanki <vikashtalanki@gmail.com> wrote:
> 
> 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