VerticaPy version 1.0.4

This minor release has some significant feature additions with other changes. Some salient ones are listed below:

Query Profiler

• Now there is a new parameter use_temp_relation which allows users to display the temporary relations separately in the get_qplan_tree.
• Query start and stop time are also included in the get_queries table.
• New queries can be added to the same schema and key using the insert function.

qprof = QueryProfiler((109090909, 1))
qprof.insert(transactions = (41823718, 2))

QueryProfilerInterface

• Made the metric selecting widgets in the QueryProfilerInterface to be more intuitive.
• A new widget allows to directly jump to the specific query without having to press Next button multiple times.
• A success flag is added to the display to confirm if the query was run successfully.
• Added unit for the query execution time.

Machine Learning

• Added Vector Auto Regression (VAR) to the list of Vertica algortihms.

vDataFrame

• The Up and Down arrow of the vDataFrame.idisplay() are now larger in size.

Bugfixes

• Bugfix for auto-token refresh using OAuth.
• Empty vDataFrame can now be created.

import pandas as pd
from verticapy import read_pandas

df = pd.DataFrame()
df = df.reindex(columns = ["col1", "col2"])
read_pandas(df)

Release Notes

Changelogs

• Full Changelog: 1.0.3...1.0.4

Installation

The release will be on available on the defaults and can be installed using:

python3 -m pip install verticapy

If you want to install extra features, use:

python3 -m pip install verticapy[all]

Please report any issues on our GitHub page

Contributors

We would like to extend our thanks to all the contributors who made this release possible:

• Badr Ouali @oualib
• Umar Farooq Ghumman @mail4umar
• Daniel Mickens @DMickens
• Tyler Consigny @tconsigny

If you would like to contribute then please visit our updated contributing guidelines.