Questions tagged [HP Vertica] (8)

1
answer

How to create a custom function with a declared variable in Vertica?

Hi all I am trying to create a custom function using variables in your functions. Vertica does not support the declared variable. Is there a workaround? How can I implement this in vertica I would be grateful for any hints or examples of usage. create or REPLACE FUNCTION itog_report_status.get_warn_lvl(day_count NUMERIC) re...
Ursula_Daugher asked April 8th 20 at 02:25
1
answer

How to transpose multiple columns into multiple rows?

It is difficult to formulate, illustrate. In the table several fields with dates, and they correspond to field values, but I don't need for each type of values(val1, val2, etc.) were separate columns in the download, I need to have a single column called value and one with values, so I wrote a query: select val1_date as dat...
Urban.Reilly93 asked April 3rd 20 at 16:42
2
answers

How to speed up a query with a function in the join condition?

There is a select with joinon the following: left join table t on t.number = left(d.number, 6) I.e., number is a kind of number-the ID, but in table d it is stored in a longer format. Therefore, when joine I use left to trim the ID to the desired number of digits, as it is stored in the table t. The problem is that it's cr...
albina_Dicki asked March 31st 20 at 14:29
1
answer

How to automate sql script(vertica)?

The challenge is to make the unloading of data from the database, now in the script, manually specify the city and number of entries - trimmed limit'ohms. I have a excel table with A list of cities and limits for each of them. How is it possible to automate? Ie roughly speaking, the script is executed as many times as cit...
fabian.Bins asked March 31st 20 at 14:19
1
answer

Is there an API for integration with HP Vertica?

Hi all! Someone integrated with hp vertica? In the Internet I can not find normal description integration capabilities with data storage. Is there any API to integrate storage over the Internet?
Lavada4 asked September 15th 19 at 08:38
1
answer

If anybody had a positive experience using vertica-python 0.7.3 version more Python 3.4?

Hello. Decided to vospolzovatsya module to connect to Verticavertica-python-0.7.3 I have a version of the interpreterpip 9.0.1 from c:\python36\lib\site-packages (python 3.6). completed the installation of the module vertica-python. took the basic code to test the connection with the same resourceimport vertica_python conn_...
Lyric.Bosco asked June 19th 19 at 11:13
1
answer

How to solve the problem with the selection keys of the JSON dictionary when loading data into Vertica?

Hello. I have a JSON object an example of the content[{'OPERATION_ID': 381, 'NAME': 'Financial data', 'LOCATION': 'Hong Kong', 'TYPE': 'Credit'},{'OPERATION_ID': 382, 'NAME': 'Financial data', 'LOCATION': 'Berlin', 'TYPE': 'Debit'}] and try to insert in Vertica DB wrote code in Pythonconn_info = {'host': 'localhost', 'port...
Lyric.Bosco asked June 18th 19 at 17:35
2
answers

How to solve the problem of adding descriptions to columns?

Hello. Trying to add a description to the columns of the table in Vertica databasecreate table um.um_users ( id number, first_name varchar2(50) not null, last_name varchar2(50) not null, password varchar2(50) not null, last_login date username varchar2(50) not null, role varchar2(50) ) ; add a reviewcomment on column um.um_...
Lyric.Bosco asked June 17th 19 at 16:14
2
answers

How to create a partition on a varchar field?

Hello. As better in the table create table WAREHOUSE.EVENT_CUSTOM_ATTRIBUTES ( event_id VARCHAR(255) not null, idx VARCHAR(255) not null, elt long varchar, ) to create a partition on a varchar field for example event_id?
Lyric.Bosco asked June 17th 19 at 13:32
2
answers

How to count the number of lines in CSV when a field larger than field limit (131072)?

Hello. Necessary from Oracle to overtake the data in Vertica. Decided to take advantage of via CSV file, since Vertica loads them fast enough. On test tables with no problems. Adopted to work with the military scheme, all is good, BUT according to statistics from Oracle to CSV took 40 000 lines, after loading in Vertica app...
Lyric.Bosco asked June 17th 19 at 13:18