HP Vertica
You can quickly import data from your HP Vertica Database into Exploratory.
Click '+' button next to 'Data Frames' and select 'Import Database Data'.

Click HP Vertica to select.

- 1.Put data frame name.
- 2.Select connection from left dialog box.
- 3.Write a query in the input field.
- 4.Click "Preview" button. Then you will see the preview of the data.
- 5.Click "Import" button.

If it looks ok, then you can click 'Import' to import the data into Exploratory.
First, create a custom R script.

Second, define a variable in the R script and save.

cutoff_date <- "\'2016-01-15\'"
Note that the ‘\’ (backslash) symbols are used to escape the single quotes, which are required to be used for characters in SQL queries.
Finally, you can use @{} to surround a variable name inside the query like below.
select *
from airline_2016_01
where fl_date > @{cutoff_date}
Last modified 1yr ago