HP Vertica
You can quickly import data from your HP Vertica Database into Exploratory.
1. Create a Connection to use
Create a connection following this instruction.
2. Open HP Vertica Import dialog
Click '+' button next to 'Data Frames' and select 'Import Database Data'.
Click HP Vertica to select.
3. Import
Put data frame name.
Select connection from left dialog box.
Write a query in the input field.
Click "Preview" button. Then you will see the preview of the data.
Click "Import" button.
If it looks ok, then you can click 'Import' to import the data into Exploratory.
4. Using Variables in SQL
First, create a custom R script.
Second, define a variable in the R script and save.
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.
Here's a blog post for more detail.
Last updated