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

```
In MySQL use where clause

```
DELETE FROM mytab 
WHERE x1 = b AND act=0 OR x1 IS NULL;;

```

Just execute this SQL and done. It will delete rows from database matching these conditions.