Spaces:

lucharo
/

etymology

Running

App Files Files Community

etymology / backend /sql /ingestion /02_create_words.sql

lucharo

Luis Chaves Rodriguez

Super-squash branch 'main' using huggingface_hub

13812dc 9 months ago

Raw History Blame Contribute Delete

274 Bytes

CREATE TABLE words AS
SELECT
    word_ix::BIGINT AS word_ix,
    lang,
    lexeme,
    sense
FROM read_csv_auto(?, delim='\t', header=false, columns={
    'word_ix': 'BIGINT',
    'lang': 'VARCHAR',
    'dummy': 'INTEGER',
    'lexeme': 'VARCHAR',
    'sense': 'VARCHAR'
})

	CREATE TABLE words AS
	SELECT
	word_ix::BIGINT AS word_ix,
	lang,
	lexeme,
	sense
	FROM read_csv_auto(?, delim='\t', header=false, columns={
	'word_ix': 'BIGINT',
	'lang': 'VARCHAR',
	'dummy': 'INTEGER',
	'lexeme': 'VARCHAR',
	'sense': 'VARCHAR'
	})