<p dir="auto">Make sure these boxes are checked before submitting your issue - thank you!</p>
<ul class="contains-task-list">
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox" checked=""> I have checked the superset logs for python stacktraces and included it here as text if any</li>
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox" checked=""> I have reproduced the issue with at least the latest released version of superset</li>
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox" checked=""> I have checked the issue tracker for the same issue and I haven't found one similar</li>
</ul>
<p dir="auto">when table include number type columns and the value is <code class="notranslate">null</code> , The TableViz cannot display this table when these columns be selected in <code class="notranslate">NOT GROUPED BY</code></p>
<h3 dir="auto">Superset version</h3>
<p dir="auto">0.26.3 On centos7  + Python 3.6.5</p>
<h3 dir="auto">Expected results</h3>
<h3 dir="auto">Actual results</h3>
<p dir="auto">Unexpected error.</p>
<h3 dir="auto">Steps to reproduce</h3>
<p dir="auto">Table DDL:<br>
<code class="notranslate"> CREATE TABLE testt ( id int(11) NOT NULL AUTO_INCREMENT, name varchar(255) DEFAULT NULL, value int(255) DEFAULT NULL, PRIMARY KEY (</code>id<code class="notranslate">) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8; </code><br>
Data:</p>
<table role="table">
<thead>
<tr>
<th>id</th>
<th>name</th>
<th>value</th>
</tr>
</thead>
<tbody>
<tr>
<td>1</td>
<td>aaa</td>
<td>1</td>
</tr>
<tr>
<td>2</td>
<td>bbb</td>
<td></td>
</tr>
<tr>
<td>3</td>
<td>ccc</td>
<td>3</td>
</tr>
<tr>
<td>4</td>
<td>ddd</td>
<td></td>
</tr>
</tbody>
</table>
<p dir="auto">And choose these three columns in TableViz's <code class="notranslate">NOT GROUPED BY</code> selector.</p>
<p dir="auto">Make sure these boxes are checked before submitting your issue - thank you!</p>
<ul class="contains-task-list">
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox" checked=""> I have checked the superset logs for python stacktraces and included it here as text if any</li>
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox" checked=""> I have reproduced the issue with at least the latest released version of superset</li>
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox" checked=""> I have checked the issue tracker for the same issue and I haven't found one similar</li>
</ul>
<h3 dir="auto">Superset version</h3>
<p dir="auto">0.26.3</p>
<h3 dir="auto">Expected results</h3>
<p dir="auto">Table View chart to load when column data contains NULL's. In previous versions it would display NULL's as 0's.</p>
<h3 dir="auto">Actual results</h3>
<p dir="auto">Unexpected Error is thrown and subsequently the table did not load.</p>
<h3 dir="auto">Steps to reproduce</h3>
<ol dir="auto">
<li>Create a table view with a data set that has a column that contains some data and the rest NULL.</li>
<li>Select column with NULL data in NOT GROUPED BY section.</li>
<li>Run Query and see "Unexpected Error"</li>
</ol>
<p dir="auto">It seems this problem only exists with multiple rows of a column containing NULL data.  I can load one row with NULL  data in columns. As soon as I load more rows I get "Unexpected Error".</p>