You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ignite.apache.org by Abhay <ab...@avissol.com> on 2020/02/06 13:16:18 UTC
SqlQuery in CPP thin client
Hi,
I checked with Java JDBC and we have the option to run query and same is
true for dot net client as well .
In CPP thin connector using CacheClient we have option to Get , Put , Remove
etc but no option to run Query . In the link given on site for binary
protocol
https://apacheignite.readme.io/docs/binary-client-protocol#client-operations
I could see the SQL and Scan queries are supported but the same protocol
seems to be missing from CPP thin client .
Can you please guide as to how to sql queries in cpp thin client .
Regards,
Abhay
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: SqlQuery in CPP thin client
Posted by Denis Magda <dm...@apache.org>.
C++ thin client will support SQL in the future. Just a matter of time.
-
Denis
On Thu, Feb 6, 2020 at 11:45 AM Abhay Gupta <ab...@avissol.com> wrote:
> Hi,
>
> Sorry I saw only the example , but all the details about ODBC connector
> were mentioned on the site and I missed it .
>
> Thanks for your help .
>
> Regards,
>
> Abhay
>
>
> On 06-Feb-2020, at 10:32 PM, Abhay Gupta <ab...@avissol.com> wrote:
>
> Hi
>
> Can you provide a reference example of using odbc driver to connect to
> ignite without using jvm where we provide the IP address if ignite node to
> connect or do you mean that only ignite odbc library has to be used and
> connection made as we do for normal odbc connection If that is the case can
> you let me know the port number to be used
>
> Regards
>
>
>
> On 06-Feb-2020, at 10:20 PM, Ilya Kasnacheev <il...@gmail.com>
> wrote:
>
>
> Hello!
>
> ODBC examples use JVM to run server node (which you obviously need), but
> ODBC driver does not have any Java dependency.
>
> Regards,
> --
> Ilya Kasnacheev
>
>
> чт, 6 февр. 2020 г. в 19:48, Abhay Gupta <ab...@avissol.com>:
>
>> Hi
>>
>> ODBC of ignite also used jvm as I saw in example and not thin client mode
>> which does not require JNI .
>>
>> Am I missing something ?
>>
>> Regards
>>
>> Abhay
>>
>> On 06-Feb-2020, at 9:43 PM, Ilya Kasnacheev <il...@gmail.com>
>> wrote:
>>
>>
>> Hello!
>>
>> You should use ODBC to do SQL queries from C/C++ code when running Ignite
>> node is not desired.
>>
>> Regards,
>> --
>> Ilya Kasnacheev
>>
>>
>> чт, 6 февр. 2020 г. в 16:16, Abhay <ab...@avissol.com>:
>>
>>> Hi,
>>>
>>> I checked with Java JDBC and we have the option to run query and same is
>>> true for dot net client as well .
>>>
>>> In CPP thin connector using CacheClient we have option to Get , Put ,
>>> Remove
>>> etc but no option to run Query . In the link given on site for binary
>>> protocol
>>>
>>>
>>> https://apacheignite.readme.io/docs/binary-client-protocol#client-operations
>>>
>>> I could see the SQL and Scan queries are supported but the same protocol
>>> seems to be missing from CPP thin client .
>>>
>>> Can you please guide as to how to sql queries in cpp thin client .
>>>
>>> Regards,
>>>
>>> Abhay
>>>
>>>
>>>
>>> --
>>> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>>>
>>
>
Re: SqlQuery in CPP thin client
Posted by Abhay Gupta <ab...@avissol.com>.
Hi,
Sorry I saw only the example , but all the details about ODBC connector were mentioned on the site and I missed it .
Thanks for your help .
Regards,
Abhay
> On 06-Feb-2020, at 10:32 PM, Abhay Gupta <ab...@avissol.com> wrote:
>
> Hi
>
> Can you provide a reference example of using odbc driver to connect to ignite without using jvm where we provide the IP address if ignite node to connect or do you mean that only ignite odbc library has to be used and connection made as we do for normal odbc connection If that is the case can you let me know the port number to be used
>
> Regards
>
>
>
>> On 06-Feb-2020, at 10:20 PM, Ilya Kasnacheev <il...@gmail.com> wrote:
>>
>>
>> Hello!
>>
>> ODBC examples use JVM to run server node (which you obviously need), but ODBC driver does not have any Java dependency.
>>
>> Regards,
>> --
>> Ilya Kasnacheev
>>
>>
>> чт, 6 февр. 2020 г. в 19:48, Abhay Gupta <abhay@avissol.com <ma...@avissol.com>>:
>> Hi
>>
>> ODBC of ignite also used jvm as I saw in example and not thin client mode which does not require JNI .
>>
>> Am I missing something ?
>>
>> Regards
>>
>> Abhay
>>
>>> On 06-Feb-2020, at 9:43 PM, Ilya Kasnacheev <ilya.kasnacheev@gmail.com <ma...@gmail.com>> wrote:
>>>
>>>
>>> Hello!
>>>
>>> You should use ODBC to do SQL queries from C/C++ code when running Ignite node is not desired.
>>>
>>> Regards,
>>> --
>>> Ilya Kasnacheev
>>>
>>>
>>> чт, 6 февр. 2020 г. в 16:16, Abhay <abhay@avissol.com <ma...@avissol.com>>:
>>> Hi,
>>>
>>> I checked with Java JDBC and we have the option to run query and same is
>>> true for dot net client as well .
>>>
>>> In CPP thin connector using CacheClient we have option to Get , Put , Remove
>>> etc but no option to run Query . In the link given on site for binary
>>> protocol
>>>
>>> https://apacheignite.readme.io/docs/binary-client-protocol#client-operations <https://apacheignite.readme.io/docs/binary-client-protocol#client-operations>
>>>
>>> I could see the SQL and Scan queries are supported but the same protocol
>>> seems to be missing from CPP thin client .
>>>
>>> Can you please guide as to how to sql queries in cpp thin client .
>>>
>>> Regards,
>>>
>>> Abhay
>>>
>>>
>>>
>>> --
>>> Sent from: http://apache-ignite-users.70518.x6.nabble.com/ <http://apache-ignite-users.70518.x6.nabble.com/>
Re: SqlQuery in CPP thin client
Posted by Abhay Gupta <ab...@avissol.com>.
Hi
Can you provide a reference example of using odbc driver to connect to ignite without using jvm where we provide the IP address if ignite node to connect or do you mean that only ignite odbc library has to be used and connection made as we do for normal odbc connection If that is the case can you let me know the port number to be used
Regards
> On 06-Feb-2020, at 10:20 PM, Ilya Kasnacheev <il...@gmail.com> wrote:
>
>
> Hello!
>
> ODBC examples use JVM to run server node (which you obviously need), but ODBC driver does not have any Java dependency.
>
> Regards,
> --
> Ilya Kasnacheev
>
>
> чт, 6 февр. 2020 г. в 19:48, Abhay Gupta <ab...@avissol.com>:
>> Hi
>>
>> ODBC of ignite also used jvm as I saw in example and not thin client mode which does not require JNI .
>>
>> Am I missing something ?
>>
>> Regards
>>
>> Abhay
>>
>>>> On 06-Feb-2020, at 9:43 PM, Ilya Kasnacheev <il...@gmail.com> wrote:
>>>>
>>>
>>> Hello!
>>>
>>> You should use ODBC to do SQL queries from C/C++ code when running Ignite node is not desired.
>>>
>>> Regards,
>>> --
>>> Ilya Kasnacheev
>>>
>>>
>>> чт, 6 февр. 2020 г. в 16:16, Abhay <ab...@avissol.com>:
>>>> Hi,
>>>>
>>>> I checked with Java JDBC and we have the option to run query and same is
>>>> true for dot net client as well .
>>>>
>>>> In CPP thin connector using CacheClient we have option to Get , Put , Remove
>>>> etc but no option to run Query . In the link given on site for binary
>>>> protocol
>>>>
>>>> https://apacheignite.readme.io/docs/binary-client-protocol#client-operations
>>>>
>>>> I could see the SQL and Scan queries are supported but the same protocol
>>>> seems to be missing from CPP thin client .
>>>>
>>>> Can you please guide as to how to sql queries in cpp thin client .
>>>>
>>>> Regards,
>>>>
>>>> Abhay
>>>>
>>>>
>>>>
>>>> --
>>>> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: SqlQuery in CPP thin client
Posted by Ilya Kasnacheev <il...@gmail.com>.
Hello!
ODBC examples use JVM to run server node (which you obviously need), but
ODBC driver does not have any Java dependency.
Regards,
--
Ilya Kasnacheev
чт, 6 февр. 2020 г. в 19:48, Abhay Gupta <ab...@avissol.com>:
> Hi
>
> ODBC of ignite also used jvm as I saw in example and not thin client mode
> which does not require JNI .
>
> Am I missing something ?
>
> Regards
>
> Abhay
>
> On 06-Feb-2020, at 9:43 PM, Ilya Kasnacheev <il...@gmail.com>
> wrote:
>
>
> Hello!
>
> You should use ODBC to do SQL queries from C/C++ code when running Ignite
> node is not desired.
>
> Regards,
> --
> Ilya Kasnacheev
>
>
> чт, 6 февр. 2020 г. в 16:16, Abhay <ab...@avissol.com>:
>
>> Hi,
>>
>> I checked with Java JDBC and we have the option to run query and same is
>> true for dot net client as well .
>>
>> In CPP thin connector using CacheClient we have option to Get , Put ,
>> Remove
>> etc but no option to run Query . In the link given on site for binary
>> protocol
>>
>>
>> https://apacheignite.readme.io/docs/binary-client-protocol#client-operations
>>
>> I could see the SQL and Scan queries are supported but the same protocol
>> seems to be missing from CPP thin client .
>>
>> Can you please guide as to how to sql queries in cpp thin client .
>>
>> Regards,
>>
>> Abhay
>>
>>
>>
>> --
>> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>>
>
Re: SqlQuery in CPP thin client
Posted by Abhay Gupta <ab...@avissol.com>.
Hi
ODBC of ignite also used jvm as I saw in example and not thin client mode which does not require JNI .
Am I missing something ?
Regards
Abhay
> On 06-Feb-2020, at 9:43 PM, Ilya Kasnacheev <il...@gmail.com> wrote:
>
>
> Hello!
>
> You should use ODBC to do SQL queries from C/C++ code when running Ignite node is not desired.
>
> Regards,
> --
> Ilya Kasnacheev
>
>
> чт, 6 февр. 2020 г. в 16:16, Abhay <ab...@avissol.com>:
>> Hi,
>>
>> I checked with Java JDBC and we have the option to run query and same is
>> true for dot net client as well .
>>
>> In CPP thin connector using CacheClient we have option to Get , Put , Remove
>> etc but no option to run Query . In the link given on site for binary
>> protocol
>>
>> https://apacheignite.readme.io/docs/binary-client-protocol#client-operations
>>
>> I could see the SQL and Scan queries are supported but the same protocol
>> seems to be missing from CPP thin client .
>>
>> Can you please guide as to how to sql queries in cpp thin client .
>>
>> Regards,
>>
>> Abhay
>>
>>
>>
>> --
>> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: SqlQuery in CPP thin client
Posted by Ilya Kasnacheev <il...@gmail.com>.
Hello!
You should use ODBC to do SQL queries from C/C++ code when running Ignite
node is not desired.
Regards,
--
Ilya Kasnacheev
чт, 6 февр. 2020 г. в 16:16, Abhay <ab...@avissol.com>:
> Hi,
>
> I checked with Java JDBC and we have the option to run query and same is
> true for dot net client as well .
>
> In CPP thin connector using CacheClient we have option to Get , Put ,
> Remove
> etc but no option to run Query . In the link given on site for binary
> protocol
>
>
> https://apacheignite.readme.io/docs/binary-client-protocol#client-operations
>
> I could see the SQL and Scan queries are supported but the same protocol
> seems to be missing from CPP thin client .
>
> Can you please guide as to how to sql queries in cpp thin client .
>
> Regards,
>
> Abhay
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>