ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From vkulichenko <valentin.kuliche...@gmail.com>
Subject Re: SQL Aliases are not interpreted correctly
Date Mon, 18 Apr 2016 21:10:18 GMT
Hi,

Aliases are supported by Ignite, but you have to use Java names when running
in-memory queries, not DB names. You should refer to the CacheConfig class
for mappings. For example, here is the entry for activity_id field:

vals.add(new JdbcTypeField(Types.BIGINT, "ACTIVITY_ID", long.class,
"activityId"));

Java field name (the one used in the object) is activityId, so the query
should start like this:

SELECT DISTINCT activity0.activityId, ...

Please let me know if it helps.

-Val



--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/SQL-Aliases-are-not-interpreted-correctly-tp4281p4298.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Mime
View raw message