{"type":"doc","content":[{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"SQL Backend представляет из себя отдельную настройку на ViQube, за счет которой запросы выполняются либо на данных ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#003366"}}]},{"text":"ViQube (In-memory)","type":"text","marks":[{"type":"textColor","attrs":{"color":"#003366"}},{"type":"strong"}]},{"text":", либо в сторонней базе (далее ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#003366"}}]},{"text":"SQL-СУБД","type":"text","marks":[{"type":"textColor","attrs":{"color":"#003366"}},{"type":"strong"}]},{"text":").","type":"text","marks":[{"type":"textColor","attrs":{"color":"#003366"}}]}]},{"type":"paragraph","content":[{"text":"Данная статья описывает как произвести настройку ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]},{"text":"SQL Backend","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}},{"type":"strong"}]},{"text":" на ViQube, что позволит ретранслировать запросы в ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]},{"text":"SQL-СУБД","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}},{"type":"strong"}]},{"text":", например ClickHouse. Полный перечень поддерживаемых СУБД приведен в ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]},{"text":"Поддерживаемые СУБД","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}},{"type":"link","attrs":{"href":"/wiki/spaces/v34/pages/214078297"}}]},{"text":".","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]}]}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Основные этапы настройки SQL Backend","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]}]},{"type":"panel","attrs":{"panelType":"warning"},"content":[{"type":"paragraph","content":[{"text":"На момент настройки в ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]},{"text":"SQL-СУБД","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}},{"type":"strong"}]},{"text":" уже должны быть таблицы, наполненные данными.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]}]}]},{"type":"paragraph","content":[{"text":"Основные этапы настройки ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]},{"text":"SQL Backend","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}},{"type":"strong"}]},{"text":":","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Создание в ViQube таблиц, идентичных в используемой","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]},{"text":" SQL-СУБД","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}},{"type":"strong"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Подготовка и применение структуры маппинга с помощью API","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]}]}]}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Создание таблиц, идентичных SQL-СУБД","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]}]},{"type":"paragraph","content":[{"text":"В ViQube необходимо создать такие же таблицы, как и в используемой ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]},{"text":"SQL-СУБД","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}},{"type":"strong"}]},{"text":". ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"ViQube б","type":"text","marks":[{"type":"textColor","attrs":{"color":"#091e42"}}]},{"text":"ерет запрос и транслирует в SQL, запрос выполняется и возвращаются данные. Эти данные попадают в таблицу с результатом. Поэтому в ViQube должна быть точно такая же структура таблицы с точно такими же типами полей, чтобы можно было вывести результирующую таблицу.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Наименования таб","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]},{"text":"лицы и столбцов м","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]},{"text":"огут отличаться, но типы данных должны быть одинаковыми. Это необходимо для корректного маппинга при трансляции запросов в ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]},{"text":"SQL-СУБД","type":"text","marks":[{"type":"textColor","attrs":{"color":"#091e42"}},{"type":"strong"}]},{"text":".","type":"text","marks":[{"type":"textColor","attrs":{"color":"#091e42"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Если в таблице в ","type":"text"},{"text":"SQL-СУБД","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}},{"type":"strong"}]},{"text":" ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]},{"text":"есть дополнительные столбцы, которых нет в таблице в ","type":"text"},{"text":"ViQube ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]},{"text":"и их использовать не планируется, то такое расхождение а таблицах допустимо. ","type":"text"},{"text":"ViQube ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]},{"text":"просто будет их игнорировать, если не указывать их в настройках ","type":"text"},{"text":"SQL Backend","type":"text","marks":[{"type":"strong"}]},{"text":".","type":"text"}]}]}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"Создать таблицы можно с помощью стандартного механизма Загрузчиков. Например, загрузив только первые 10 строк. В дальнейшем при подключении этой таблицы к","type":"text"},{"text":" ","type":"text","marks":[{"type":"strong"}]},{"text":"SQL-СУБД","type":"text","marks":[{"type":"textColor","attrs":{"color":"#091e42"}},{"type":"strong"}]},{"text":" данные из ViQube будут игнорироваться. Описание создания таблиц с помощью загрузчиков приводится в разделе: ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#091e42"}}]},{"text":"Загрузка данных и создание многомерной модели данных","type":"text","marks":[{"type":"textColor","attrs":{"color":"#091e42"}},{"type":"link","attrs":{"href":"/wiki/spaces/v34/pages/214077279"}}]},{"text":".","type":"text","marks":[{"type":"textColor","attrs":{"color":"#091e42"}}]}]}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Настройка SQL Backend","type":"text"}]},{"type":"paragraph","content":[{"text":"Работа с ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]},{"text":"SQL Backend","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}},{"type":"strong"}]},{"text":" на ViQube происходит с помощью запросов по API. ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Проверка текущих настроек - GET","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}},{"type":"strong"}]}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Чтобы просмотреть текущие настройки ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#003366"}}]},{"text":"SQL Backend ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#003366"}},{"type":"strong"}]},{"text":"необходимо отправить GET-запрос:","type":"text","marks":[{"type":"textColor","attrs":{"color":"#003366"}}]}]},{"type":"codeBlock","attrs":{"language":"xml"},"content":[{"text":"curl --location --request GET 'http://192.168.4.101/viqube/sqlbackend' \\\n--header 'X-API-VERSION: 3.8' \\\n--header 'Authorization: 'Bearer '","type":"text"}]},{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"

IP адрес, HTTP/HTTPS и <Bearer token> необходимо заменить на свои. Как получить <Bearer token> описано в разделе .
X-API-VERSION 3.8 актуальна для 2.27, и может быть другой для вашей версии платформы.
На время тестирования авторизацию на ViQube можно отключить, в таком случае заголовок Authorization не нужен.

","block-inline":true,"nestedContent":{"type":"doc","content":[{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"IP адрес, HTTP/HTTPS и необходимо заменить на свои. Как получить ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]},{"text":" описано в разделе ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]},{"text":"Получение токена аутентификации","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/v34/pages/214077490"}},{"type":"textColor","attrs":{"color":"#172b4d"}}]},{"text":".","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]},{"text":" ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]},{"type":"hardBreak"},{"text":"X-API-VERSION 3.8 актуальна для 2.27, и может быть другой для вашей версии платформы. ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]},{"type":"hardBreak"},{"text":"На время тестирования авторизацию на ViQube можно отключить, в таком случае заголовок Authorization не нужен.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]}]}]}],"version":1},"reason":"Макрос информации в элементе списка нельзя создать или изменить в новом редакторе."}}}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"В ответе получаем следующие настройки","type":"text"},{"text":" SQL Backend","type":"text","marks":[{"type":"strong"}]},{"text":" (по умолчанию):","type":"text"}]},{"type":"codeBlock","content":[{"text":"{\n \"enabled\": false,\n \"jdbcOptions\": {\n \"connection\": \"\"\n },\n \"sqlMapping\": {}\n}","type":"text"}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Применение новых настроек - PUT","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}},{"type":"strong"}]}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Чтобы применить новые настройки SQL Backend необходимо отправить PUT-запрос с подготовленными настройками. Подробное описание структуры настроек приведено в разделе ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]},{"text":"\"Структура настроек SQL Backend\"","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}},{"type":"strong"}]},{"text":".","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"В случае успешного применения настроек будет возвращено \"200\".","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"После успешного применения настроек все таблицы, которые были настроены на ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]},{"text":"SQL-СУБД","type":"text","marks":[{"type":"textColor","attrs":{"color":"#091e42"}},{"type":"strong"}]},{"text":" при запросах будут обращаться напрямую в SQL-СУБД, а не ViQube.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#091e42"}}]}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Структура настроек SQL Backend","type":"text","marks":[{"type":"textColor","attrs":{"color":"#091e42"}},{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Настройки ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#091e42"}}]},{"text":"SQL Backend","type":"text","marks":[{"type":"textColor","attrs":{"color":"#091e42"}},{"type":"strong"}]},{"text":" состоят из:","type":"text","marks":[{"type":"textColor","attrs":{"color":"#091e42"}}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":" строки подключения, параметров подключения","type":"text","marks":[{"type":"textColor","attrs":{"color":"#091e42"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"описания соответствия таблиц и колонок в ViQube и ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#091e42"}}]},{"text":"SQL-СУБД","type":"text","marks":[{"type":"textColor","attrs":{"color":"#091e42"}},{"type":"strong"}]}]}]}]},{"type":"table","attrs":{"layout":"full-width","localId":"1ffd7b3b-1a4c-4f27-9e00-61761873347c"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":2,"rowspan":1,"colwidth":[97.21,154.18]},"content":[{"type":"paragraph","marks":[{"type":"alignment","attrs":{"align":"center"}}],"content":[{"text":"Параметр","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[1028.66]},"content":[{"type":"paragraph","marks":[{"type":"alignment","attrs":{"align":"center"}}],"content":[{"text":"Описание","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":2,"rowspan":1,"colwidth":[97.21,154.18]},"content":[{"type":"paragraph","content":[{"text":"enabled","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1028.66]},"content":[{"type":"paragraph","content":[{"text":"Включен или выключен ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]},{"text":"SQL Backend","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}},{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":2,"rowspan":1,"colwidth":[97.21,154.18]},"content":[{"type":"paragraph","content":[{"text":"jdbcOptions","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1028.66]},"content":[{"type":"paragraph","content":[{"text":"Настройки и опции подключения к ","type":"text"},{"text":"SQL-СУБД","type":"text","marks":[{"type":"textColor","attrs":{"color":"#091e42"}},{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[97.21]},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[154.18]},"content":[{"type":"paragraph","content":[{"text":"connection","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1028.66]},"content":[{"type":"paragraph","content":[{"text":"Строка подключения для JDBC драйвера. Адрес в строке необходимо указать такой, чтобы он был доступен изнутри контейнера viqube-master","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[97.21]},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[154.18]},"content":[{"type":"paragraph","content":[{"text":"isResetUpdateTime","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1028.66]},"content":[{"type":"paragraph","content":[{"text":"\"","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]},{"text":"true","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}},{"type":"strong"}]},{"text":"\" - сбрасывать кэш при каждом запросе.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]}]},{"type":"paragraph","content":[{"text":"\"","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]},{"text":"false","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}},{"type":"strong"}]},{"text":"\" - ответы кэшируются (может быть использован для ускорения работы дашбордов)","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[97.21]},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[154.18]},"content":[{"type":"paragraph","content":[{"text":"socket_timeout ","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1028.66]},"content":[{"type":"paragraph","content":[{"text":"Таймаут для выполнения запросов в ","type":"text"},{"text":"SQL-СУБД ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#091e42"}},{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":2,"rowspan":1,"colwidth":[97.21,154.18]},"content":[{"type":"paragraph","content":[{"text":"sqlMapping","type":"text","marks":[{"type":"strong"}]},{"text":" ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1028.66]},"content":[{"type":"paragraph","content":[{"text":"Перечисляются все таблицы, запросы для которых нужно транслировать в ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]},{"text":"SQL-СУБД","type":"text","marks":[{"type":"textColor","attrs":{"color":"#091e42"}},{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[97.21]},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[154.18]},"content":[{"type":"paragraph","content":[{"text":"Ключ ","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1028.66]},"content":[{"type":"paragraph","content":[{"text":"Имя таблицы в ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]},{"text":"ViQube (In-memory)","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}},{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[97.21]},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[154.18]},"content":[{"type":"paragraph","content":[{"text":"sqlTable","type":"text","marks":[{"type":"strong"}]},{"text":" ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1028.66]},"content":[{"type":"paragraph","content":[{"text":"Имя таблицы в ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]},{"text":"SQL-СУБД. ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#091e42"}},{"type":"strong"}]},{"text":"Е","type":"text","marks":[{"type":"textColor","attrs":{"color":"#091e42"}}]},{"text":"сли имена совпадают можно не писать это поле, или указать ““.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"Если таблица не указана, то запросы с участием этой таблицы не будут транслироваться в ","type":"text"},{"text":" ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]},{"text":"SQL-СУБД","type":"text","marks":[{"type":"textColor","attrs":{"color":"#091e42"}},{"type":"strong"}]}]}]},{"type":"paragraph","content":[{"type":"hardBreak"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[97.21]},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[154.18]},"content":[{"type":"paragraph","content":[{"text":"columns","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1028.66]},"content":[{"type":"paragraph","content":[{"text":"Перечисляются все поля (столбцы) таблиц, запросы для которых нужно транслировать в SQL.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"Если имя столбца в таблице в ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]},{"text":"ViQube (In-memory) ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}},{"type":"strong"}]},{"text":"и в таблице в ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]},{"text":"SQL-СУБД","type":"text","marks":[{"type":"textColor","attrs":{"color":"#091e42"}},{"type":"strong"}]},{"text":" совпадают и это не столбец с типом \"Дата\" или \"ДатаВремя\", то указывать его в секции не нужно","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]}]},{"type":"paragraph","content":[{"text":"Если имя столбца в таблице в ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]},{"text":"ViQube (In-memory) ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}},{"type":"strong"}]},{"text":"и в таблице в ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]},{"text":"SQL-СУБД","type":"text","marks":[{"type":"textColor","attrs":{"color":"#091e42"}},{"type":"strong"}]},{"text":" ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]},{"text":"НЕ","type":"text","marks":[{"type":"underline"},{"type":"textColor","attrs":{"color":"#172b4d"}},{"type":"strong"}]},{"text":" совпадают и это ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]},{"text":"НЕ","type":"text","marks":[{"type":"underline"},{"type":"textColor","attrs":{"color":"#172b4d"}},{"type":"strong"}]},{"text":" столбец с типом \"Дата\" или \"ДатаВремя\",то указывать нужно:","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]}]},{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"

","block-inline":true,"nestedContent":{"type":"doc","content":[{"type":"codeBlock","content":[{"text":"\"name_in_viqube\": {\"OFF\": \"name_in_sql\"}","type":"text"}]}],"version":1}}}}]},{"type":"paragraph","content":[{"text":"Для всех полей с типом \"Дата\" или \"ДатаВремя\" нужно задавать правила замещения колонок, так как в ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]},{"text":"ViQube (In-memory)","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}},{"type":"strong"}]},{"text":" есть свои особенности в работе с датой.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]}]}]},{"type":"paragraph","content":[{"type":"hardBreak"}]}]}]}]},{"type":"panel","attrs":{"panelType":"warning"},"content":[{"type":"paragraph","content":[{"text":"Если в базе данных используется схема, то необходимо обрамлять в кавычки название схемы и название таблицы. Например:","type":"text"}]},{"type":"paragraph","content":[{"text":"\"sqlTable\": \"\\\"scheme\\\".\\\"table\\\"\"","type":"text","marks":[{"type":"code"}]}]},{"type":"paragraph","content":[{"text":"Строка типа ","type":"text"},{"text":"\"sqlTable\":\"scheme.table\"","type":"text","marks":[{"type":"code"}]},{"text":" работать не будет.","type":"text"}]}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"Шаблоны для настроек поддерживаемых СУБД приведены в разделе: ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]},{"text":"Примеры структур настроек для СУБД","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}},{"type":"link","attrs":{"href":"/wiki/spaces/v34/pages/214078609"}}]},{"text":".","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]}]}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Отключение SQL Backend","type":"text"}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"Чтобы выключить режим SQL Backend на некоторых таблицах достаточно отправить обновленный PUT-запрос, в котором НЕ будет этих таблиц.","type":"text"}]}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Чтобы ","type":"text"},{"text":"полностью","type":"text","marks":[{"type":"strong"}]},{"text":" ","type":"text"},{"text":"выключить","type":"text","marks":[{"type":"strong"}]},{"text":" режим SQL Backend необходимо отправить PUT-запрос:","type":"text"}]},{"type":"codeBlock","attrs":{"language":"xml"},"content":[{"text":"{\n \"enabled\": false,\n \"jdbcOptions\": {\n \"connection\": \"\"\n },\n \"sqlMapping\": {}\n}","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"В случае успешного применения настроек будет возвращено \"200\".","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Теперь при запросе настроек с помощью GET-запроса, будут возвращены исходные настройки:","type":"text"}]},{"type":"codeBlock","content":[{"text":"{\n \"enabled\": false,\n \"jdbcOptions\": {\n \"connection\": \"\"\n },\n \"sqlMapping\": {}\n}","type":"text"}]}]}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Пример настройки","type":"text"}]},{"type":"paragraph","content":[{"text":"Пример настройки SQL Backend на ClikHouse:","type":"text"}]},{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"multimedia","parameters":{"macroParams":{"name":{"value":"SQL Backend (общая настройка).mp4"}},"macroMetadata":{"macroId":{"value":"f3a30c92-dcfc-4941-8d59-205f25765534"},"schemaVersion":{"value":"1"},"title":"confluence.macros.multimedia.multimedia.label"}},"localId":"e20fb9cc-2de4-47b2-9f9c-6c5f3e102899"}},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"paragraph","content":[{"type":"hardBreak"}]}],"version":1}

Браузер не поддерживается