ALTER CONTEXT - Kinetica Docs

Alters the configuration of a SQL-GPT context. Multiple context entries can be added & removed in one command. The general form is:

ALTER CONTEXT Syntax

ALTER CONTEXT [<schema name>.]<context name>
[ADD | DROP] <context entry>,
...
[ADD | DROP] <context entry>

Add Context Table

A context table can be added to a SQL-GPT context.

Add Context Table Syntax

ALTER CONTEXT [<schema name>.]<context name>
ADD <table definition clause>

See Table Definition Clause for syntax of the <table definition clause>.

Examples

To add the example.atc_country table to the example.atc_ctx SQL-GPT context:

Add Context Table Example

ALTER CONTEXT example.atc_ctx
ADD
(
	TABLE = example.atc_country
	COMMENT = 'Countries containing airports'
)

Drop Context Table

A context table can be removed from a SQL-GPT context.

Drop Context Table Syntax

ALTER CONTEXT [<context schema name>.]<context name>
DROP (TABLE = [<table schema name>.]<table name>)

Examples

To drop the example.atc_country table from the example.atc_ctx SQL-GPT context:

Drop Context Table Example

ALTER CONTEXT example.atc_ctx
DROP (TABLE = example.atc_country)

Add Context Samples

Context samples can be added to a SQL-GPT context that has not been configured with any. To add samples to a context already configured with one or more, first drop all existing samples, and then add the new and any previous samples all at once.

Add Context Samples Syntax

ALTER CONTEXT [<schema name>.]<context name>
ADD <sample definition clause>

See Sample Definition Clause for syntax of the <sample definition clause>.

Examples

To add a sample query for finding JFK airport’s location to the example.atc_ctx SQL-GPT context:

Add Context Samples Example

ALTER CONTEXT example.atc_ctx
ADD
(
	SAMPLES =
	(
		'What is the centroid of JFK airport?' =
		'
			SELECT airport_centroid
			FROM example.airport_positions
			WHERE airport_code = ''JFK''
		'
	)
)

Drop Context Samples

Context samples can be removed from a SQL-GPT context that has been configured with one or more.

Drop Context Samples Syntax

ALTER CONTEXT [<context schema name>.]<context name>
DROP (SAMPLES = ('' = ''))

Examples

To drop all context samples from the example.atc_ctx SQL-GPT context:

Drop Context Samples Example

ALTER CONTEXT example.atc_ctx
DROP (SAMPLES = ('' = ''))

Add Context Rules

Context rules can be added to a SQL-GPT context that has not been configured with any. To add rules to a context already configured with one or more, first drop all existing rules, and then add the new and any previous rules all at once.

Add Context Rules Syntax

ALTER CONTEXT [<schema name>.]<context name>
ADD <rule definition clause>

See Rule Definition Clause for syntax of the <rule definition clause>.

Examples

To add a rule for joining the example.airport_positions table with the atc_current_position table to the example.atc_ctx SQL-GPT context:

Add Context Rules Example

ALTER CONTEXT example.atc_ctx
ADD
(
	RULES =
	(
		'
			Use the ST_CONTAINS() function to join the airport_centroid column of the
			airport_positions table with the x and y columns of the atc_current_position table
		'
	)
)

Drop Context Rules

Context rules can be removed from a SQL-GPT context that has been configured with one or more.

Drop Context Rules Syntax

ALTER CONTEXT [<context schema name>.]<context name>
DROP (RULES = (''))

Examples

To drop all context rules from the example.atc_ctx SQL-GPT context:

Drop Context Rules Example

ALTER CONTEXT example.atc_ctx
DROP (RULES = (''))

​Add Context Table

​Examples

​Drop Context Table

​Examples

​Add Context Samples

​Examples

​Drop Context Samples

​Examples

​Add Context Rules

​Examples

​Drop Context Rules

​Examples

Add Context Table

Examples

Drop Context Table

Examples

Add Context Samples

Examples

Drop Context Samples

Examples

Add Context Rules

Examples

Drop Context Rules

Examples