I noticed Drop was not supported in hive connector and since Im sourcing data from ADLS I can only use HIVE (external table creation), is it possible to drop rows when creating a view?
Drop table is supported. If you want to delete individual rows you will need to use Delta or Iceberg connector as they support delete.
Also note that a view just assembles the data from the source tables, and is run each time you access the view. So if you want a row to disappear from a view … you have to delete the row in the source table or update the view definition.