Feature request: better auto-completion

[getaaron]

Problems

• For very large databases, we are experiencing a ~20 sec delay when switching using use
• Autocompletion only works for 1 database at a time (e.g. doesn't work for cross-database queries)

Possible solutions

• Fetch auto completions on SELECT database_name.<tab>
• Get all the autocompletions up-front?
• Cache when switching databases?
• Make it configurable?

[zzl0]

I am not sure. We can check mycli/pgcli to see if they already support it, if yes, we can just copy the logic to athenacli.

[littlefattiger]

@zzl0 This also be an issue for us. We have very large databases on s3, and whenever we use some shcema, the first query will be very slow(>10 mins) because it automatically run the query to get out all the tables and column names to help us auto-complete.

Possible solution:

1. Distable this auto-complete function to make the first query also fast?
2. Cached the table name and tables in some place and dont need to run it every time?