How to count columns each table

User: Improvements and Howto
#1

I can’t use INFORMATION_SCHEMA
[Error 10001]: Table not found ‘INFORMATION_SCHEMA’
and can’t use sys.columns
[Error 10001]: Table not found ‘columns’

Cloudera Express 6.2.0