@Althotta I do not think this is possible for the create to reference schema registry, only insert/update. To do this table creation in NiFi you will need to do some flowfile content manipulation work to fabricate the CREATE TABLE statement. For example if the flowfile content is the avro schema (you could get this form the schema registry API) then you can parse out the columns and data types to get the middle of the create statement:
(col_name data_type [COMMENT 'col_comment'],, ...)
then a ReplaceText processor to add the top lines:
CREATE [EXTERNAL] TABLE [IF NOT EXISTS] [db_name.]table_name
and bottom lines:
[COMMENT 'table_comment'] [ROW FORMAT row_format] [FIELDS TERMINATED BY char] [STORED AS file_format];
This would give you a full create statement which you can then execute against Hive.