Basic API#
To begin your querying session, get a connection to the EvaDB using connect
:
import evadb
from eva.interfaces.relational.db import EVAConnection, connect
conn = connect()
You can then use this connection to run queries:
conn.load("online_video.mp4", "youtube_video", "video").execute()
conn.query("CREATE TABLE IF NOT EXISTS youtube_video_text AS SELECT SpeechRecognizer(audio) FROM youtube_video;").execute()
Warning
It is important to call execute
to run the actual query.
EvaDB uses a lazy query execution technique to improve performance.
Calling conn.query("...")
will only construct and not run the query. Calling conn.query("...").execute()
will both construct and run the query.
EVAConnection Interface#
EVARelation Interface#
|
Projects a set of expressions and returns a new EVARelation. |
|
Transform the relation into a result set |
|
Execute a expr on all the rows of the relation |
|
Filters rows using the given condition. |
|
Execute and fetch all rows as a pandas DataFrame |
Advanced API#
EVAConnection Interface#
|
Create a vector index on a table in the database. |
|
Get the result of the last executed query on the connection as a pandas DataFrame. |