Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Leading capital letter in branch dictionary-clickhouse #15

Open
nitzan-tz opened this issue Aug 4, 2020 · 0 comments
Open

Leading capital letter in branch dictionary-clickhouse #15

nitzan-tz opened this issue Aug 4, 2020 · 0 comments

Comments

@nitzan-tz
Copy link

In branch dictionary-clickhouse
When you create the DB you are using small letters for dictionaries.protocols but in the CSV you are using leading capital letter
It cause error in the Grafana dashboard for ports
Please change the DB to have leading capital letter

CREATE DATABASE dictionaries; 

CREATE DICTIONARY dictionaries.protocols (   \
    Proto UInt8,  \
    Name String,  \
    Description String   \
)  \
PRIMARY KEY Proto   \ 
LAYOUT(FLAT())  \
SOURCE (FILE(path '/var/lib/clickhouse/user_files/protocols.csv' format 'CSVWithNames'))  \
LIFETIME(3600);  
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant