How to create roles and views in MapD?


I have a table in MapD of 10 columns and 2 user one is admin and other is executive , what i want is when is admin query over the table it able to access all columns of table but executive is able to access 8 columns only .So is it possible in mapD because in normal database we make views and Roles in database to do this thing.



Views can be created via the regular syntax CREATE VIEW AS ......

As far as roles and access control goes this is being worked on currently and so keep an eye on the release notes for up coming releases as to when that lands.