sqlline not showing all columns of a Ignite table on terminal

Question

I've created a table in Ignite which has more than 20 columns. Now, on sqlline I can only see five columns of that table out of 20 columns when query the data like "select * from table_name". Is there any way to do that in sqlline?

score 2 · Answer 1 · answered May 05 '20 at 19:47

2

SQL line can't show so many columns horizontally properly, so you can use vertical mode:

!outputformat vertical

answered May 05 '20 at 19:47

Evgenii Zhuravlev

2,987
1
9
15

I've already checked vertical mode but it's not giving output in proper tabular format. – sandipbhowmik May 05 '20 at 19:50

score 1 · Accepted Answer · answered May 06 '20 at 09:06

1

Try the following sqlline command:

!set maxWidth 1000

answered May 06 '20 at 09:06

alamar

18,729
4
64
97

sqlline not showing all columns of a Ignite table on terminal

2 Answers2