jobrad / hive-sql-vscode Goto Github PK

Thanks,
https://docs.cloudera.com/HDPDocuments/HDP2/HDP-2.6.5/bk_data-access/content/new-feature-insert-values-update-delete.html

The link is here: https://github.com/aaron-bond/better-comments
I really love your extension for hive syntax highlighting! However I couldn't get this working in conjunction with better-comments... it's a shame that two great packages cannot work together.

Thanks!

the sublime extension supported code completion using function, i.e.: when using the regexp_extract, it would auto complete it and give you the appropriate placeholders.

Good work!

How to start formatter ?

Thanks,
Charlie

Thanks bro.

Please add keyword "and"/"or" in WHERE statement. I found "and" can not be identified as a keyword. Thanks!

I was able to successfully install the extension and view an .hql file with the advertised formatting. However, I am unable to view any available snippets using ctrl + space or complete a snippet with tab while typing "CREATE".

Issue Type: Bug

The IDE displays an error when trying to parameterize a Hive table name prefix.

SET TblPrefix=tbl_prefix;
SET TransDB=dev_db;
SET TransLocation=wasb://container@cluster/data/dev;

CREATE TABLE IF NOT EXISTS ${hiveconf:TransDB}.${hiveconf:TblPrefix}_test_table
(
test INT
)
PARTITIONED BY (partition_date STRING)
STORED AS ORC
LOCATION '${hiveconf:TransLocation}/${hiveconf:Prefix}_test_table';

Extension version: 0.0.2
VS Code version: Code - Insiders 1.22.0-insider (6b4d53cdab8bcae1eaaa4934d93c077319b573db, 2018-04-04T13:52:38.747Z)
OS version: Windows_NT x64 10.0.16299

When keywords or function names appear in a column name enclosed by back ticks, the color formatting appears as functions instead of as a column name. (I would never name table columns as in the example, except to meet requirements.)

hi bro，can u add function hint？
like
date_format(${1:date},${2:format})
?

when format:

There is no formatter for 'hive-sql' files installed.