Firstly, sorry for my English.
I start to use Apache Ignite with PHP (PDO, UnixODBC, Ignite ODBC driver). I
successfully installed it and configured Ignite, DSN and ODBC on my linux
server (Debian). I installed php-odbc extension and everything looks well.
I start Apache Ignite by: ./bin/ignite.s
Hi and thank you for your answer.
Im not test mysql with odbc driver and at this moment my goal is to find
more faster solution like mysql. I know that mysql is working on native
mysql driver and ODBC is a third-party driver but this is recommended
solution in official Apache Ignite documentation:
Maybe Im not explain everythinnk correctly. I run mysql queries by PHP of
course
So, one more time:
I prepare the same database, first db in MySQL and second in Apache Ignite.
Database have the same size and number of rows (~6 milion rows).
I prepare the same PHP script (as in my first post) use
Thanks for reply.
What do you mean with "warmed up" the JVM prior testing?
How can I do this?
Do you mean to prepare JAVA application with some SQL queries like my PHP
scripts from first post, and run it in JVM to check query time?
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
ok, I will try to build cluster on 3 machines and I will prepare tests one
more time.
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Ok, thank you for reply. Now I understand where is mistake.
See you soon :)
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Hi,
My question is: Is it possible to import existing mysql database from file
in console?
In mysql I do: mysql -u myuser -p mydatabase < verybigdatabase.sql
Is it posible to do something similar in apache ignite? How Can I import
existind database to Ignite?
--
Sent from: http://apache-ignit
Ok, thanks for reply. It's helpful.
I have another question: What about backup? I storage my database in memory,
what happened if Apache Ignite is stopping? Do I lose my data? Haw Can I do
backup and if is nessesery load it to the cluster? Does apache ignite
provide tools for do this, or I must wr
Hi,
I have problem with creating table and insert example data. I use PHP, ODBC
and Apache Ignite. I create simple script to do it:
// create table:
$sql = 'CREATE TABLE test_md5 (id int PRIMARY KEY, userkey varchar(255),
server text, tsession text, tpost text, tget text, adddate int)';
$ignite-
Thank you very much. This is the answer. So, I understend that in ODBC best
equivalent of TEXT type is LONGVARCHAR?
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Hello I try to create table with TEXT type. TEXT data type is not supported
by ODBC driver but I can use types like: VARCHAR or LONGVARCHAR.
Problem is that every time my text is truncating to 64 characters. Why? Haw
Can I configure Apache Ignite / unixODBC to work with normal TEXT type?
I tested
Hello, I refresh this post
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
So, I use Apache Ignite in 2.3.0 version.
Im not C# programmer but I compile attached C# example by mono:
mcs -out:odbcvarchar.exe -r:System.dll -r:System.Data.dll odbcvarchar.cs
And after when I run it I have fallowing errors:
[ERROR] FATAL UNHANDLED EXCEPTION: System.EntryPointNotFoundExcepti
Yes, and maybe will difficult to find solution on this error:
https://bugzilla.xamarin.com/show_bug.cgi?id=37368
If will be nessesery I can try to prepare VS 2017 and compile it one more
time...
So, here is my simple script:
setAttribute(PDO::ATTR_ERRMODE,
PDO::ERRMODE_EXCEPTION);
Ok, thank you very much for your time nad reply.
So, if I understend corectly, this is bug of Apache Ignite. How much time
will take to resolve and fix this problem?
I will track progress :)
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
ok,
I ask becouse I wont to be sure. Fix will be included in Ignite 2.4 or 2.5?
On the ticket: https://issues.apache.org/jira/browse/IGNITE-7362 in details
is write that fix this bug is planning for 2.5 version...
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Hello,
So, I was testing today fix of this bug and well... I have similar error.
Different is that before I had truncated string and now I have NULL when I
try to add more longer string.
My Ignite version is: Ignite ver.
2.5.0-SNAPSHOT#20180228-sha1:6641267df826e74213c9921e1d0c3490f09aae45
When
I'm try to execute fallowing code:
setAttribute(PDO::ATTR_ERRMODE,
PDO::ERRMODE_EXCEPTION);
$sql = 'CREATE TABLE IF NOT EXISTS test_md5 (id int PRIMARY
KEY, userkey
LONGVARCHAR, server LONGVARCHAR, tsession LONGVARCHAR, tpost LONGVARCHAR,
tget LONGVARCHAR, adddate i
Yes,
Here is my libignite-odvc.so. Command "ldd /usr/local/lib/libignite-odbc.so"
show:
linux-vdso.so.1 (0x7fff18aad000)
libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x7f96a60f7000)
libignite-binary-2.5.0.26265.so.0 => not found
libodbcinst.so.2 => /usr/
Hello,
I try to compile odbc but I have fallowing errors:
So I make fallowing commands:
1. cd ./modules/platforms/cpp
2. libtoolize && aclocal && autoheader && automake --add-missing &&
autoreconf
3. ./configure
4. make
Errors are:
error: 'ignite::odbc::ssl::OPENSSL_init_ssl' declared as an '
I have libssl-dev in newest version. Before compile I install gcc g++ make
automake libtool m4 libssl-dev unixodbc unixodbc-dev
So I have all dependencies from DEVNOTES.txt :
* GCC, g++, autotools, automake, and libtool must be installed
* Java Development Kit (JDK) must be installed:
https://j
ok, here are whole console logs:
make[3]: Entering directory '/root/ignite/modules/platforms/cpp/odbc'
[0/1251]
CXX src/ssl/secure_socket_client.lo
In file included from ./include/ignite/odbc/ssl/ssl_
So, cammand line: "apt-cache policy openssl" show:
openssl:
Installed: 1.0.1t-1+deb8u7
Candidate: 1.0.1t-1+deb8u7
Version table:
*** 1.0.1t-1+deb8u7 0
500 http://http.us.debian.org/debian/ jessie/main amd64 Packages
500 http://security.debian.org/ jessie/updates/main amd64 P
Thanks Igor, I will be grateful.
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
24 matches
Mail list logo
