Question: When we are using hive, data is not displayed in perfect table format. Column name and actual data related to column differs in position if the column name is big. How to fix it?

Answer: 
You specified the condition in `WHERE` clause

for the condition that you required

```
DELETE d
FROM   mytab d
WHERE (
          d.x1 = 'b' AND d.act = 0
      )
OR    d.x1 is null

```
For deleting rows,use `Delete` statement instead of `select` and the table name and then `where` clause for putting condition 

```
 Detele t1
     from mytab t1
    where 
     (  x1=b  and act=0
     ) OR x1 IS NULL

```

here t1 is alias of table mytab