Posted by
Harmeet Singh on
Oct 20, 2016; 11:00am
URL: http://apache-carbondata-dev-mailing-list-archive.168.s1.nabble.com/describe-formatted-table-command-does-not-show-block-size-tp2098.html
Hey team, carbon data creating a table block size with 1GB default value. But when i am trying to show the block size value using desc formatted <table-name>, the detail is show, but block size doest not appear. I suggest in tables details the block size must be visible. Even we manually define the table block size, the size does not appear. Following are the details:
First table automatic block size:
0: jdbc:hive2://127.0.0.1:10000> create table testOne(name string, age int) stored by 'carbondata';
0: jdbc:hive2://127.0.0.1:10000> desc formatted testOne;
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--+
| result |
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--+
| name string DICTIONARY, KEY COLUMN |
| age bigint MEASURE |
| |
| ##Detailed Table Information |
| Database Name : fordrop |
| Table Name : testone |
| CARBON Store Path : hdfs://localhost:54310/Opt/CarbonStore |
| |
| ##Detailed Column property |
| NONE |
| |
| ##Column Group Information |
Second Table manually block size: 0: jdbc:hive2://127.0.0.1:10000> create table testTwo(name string, age int) stored by 'carbondata' tblproperties('table_blocksize"="1");
0: jdbc:hive2://127.0.0.1:10000> desc formatted testTwo;
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--+
| result |
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--+
| name string DICTIONARY, KEY COLUMN |
| age bigint MEASURE |
| |
| ##Detailed Table Information |
| Database Name : fordrop |
| Table Name : testtwo |
| CARBON Store Path : hdfs://localhost:54310/Opt/CarbonStore |
| |
| ##Detailed Column property |
| NONE |
| |
| ##Column Group Information |
Please confirm this is an issue ?