search

sanchezzzhak / kak-clickhouse

Yii2 ext. ClickHouse
69 stars 43 forks source link

batchInsert сonverts float numbers to a string #17

Closed rkashapov2015 closed 6 years ago

rkashapov2015 commented 6 years ago

Hello, Im create array, in which there are numbers with a floating point array( null, "94.180.249.59", "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.115 Safari/537.36", "/test/test/test/", 200, "GET", "ddfdfdf", 55.796539, 49.1082, "RU", "Республика Татарстан", "Казань", 1501228567 ) and I see raw sql $command->getRawSql(); "INSERT INTO logs (user_id, ip, agent, url, status, request_method, params, lat, lng, country, region, city, created_at) VALUES (NULL, '94.180.249.59', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.115 Safari/537.36', '/test/test/test/', 200, 'GET', 'ddfdfdf', '55.796539', '49.1082', 'RU', 'Республика Татарстан', 'Казань', '1501228567'), (NULL, '94.180.249.59', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.115 Safari/537.36', '/test/test/test/', 200, 'GET', 'ddfdfdf', '55.796539', '49.1082', 'RU', 'Республика Татарстан', 'Казань', '1501229092'), (NULL, '94.180.249.59', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.115 Safari/537.36', '/test/test/test/', 200, 'GET', 'ddfdfdf', '55.796539', '49.1082', 'RU', 'Республика Татарстан', 'Казань', '1501229094')"

rkashapov2015 commented 6 years ago

added name database in the name table and everything was fine. sorry.