I am trying to use vehicle identification number (VIN) as a field in an
apache ignite cache. I am using version 2.2. The form of this string is 17
characters in length and contains alphanumeric character outside of the
hexadecimal digit range. I am getting errors similar to this thread
<http://apache-ignite-users.70518.x6.nabble.com/How-to-load-2-tables-in-a-cache-td4026.html#a4100>
where the string in a where clause is evaluated as a hexadecimal string and
fails to return any results. I am having to concatenate a string that is
clearly *not *hexadecimal to get any values to return.
Caused by: org.h2.jdbc.JdbcSQLException: Hexadecimal string with odd number
of characters:
examples of working queries:
select * from "vin_raw".VEHICLETIMESERIESDATA vs where 'VIN' || vin = 'VIN'
|| '1G1BB5SM1H7130073';
SELECT _key, _val FROM "vin_raw".VEHICLETIMESERIESDATA where 'vin' || vin =
'vin1G1BB5SM1H7130073' and name = 'Foo';
SELECT _key, _val FROM "vin_raw".VEHICLETIMESERIESDATA where name = 'Foo';
SELECT * FROM "vin_raw".VEHICLETIMESERIESDATA;
examples that fail:
select count(*) from "vin_raw".VEHICLETIMESERIESDATA vs where vin =
'1G1BB5SM1H7130073';
SELECT _key, _val FROM "vin_raw".VEHICLETIMESERIESDATA where vin =
'1G1BB5SM1H7130073' and name = 'Foo';
<property name="fields">
<map>
<entry key="vin" value="java.lang.String" />
<entry key="name"
value="java.lang.String" />
<entry key="lastModifiedTimeMillis"
value="java.lang.Long"/>
<entry key="createdTimeMillis"
value="java.lang.Long" />
<entry key="internalMap"
value="java.util.SortedMap" />
</map>
</property>
<property name="indexes">
<list>
<bean class="org.apache.ignite.cache.QueryIndex">
<constructor-arg>
<list>
<value>vin</value>
<value>name</value>
<value>lastModifiedTimeMillis</value>
</list>
</constructor-arg>
<constructor-arg value="SORTED"/>
</bean>
</list>
</property>
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
