def create_table_command(table, schema):
    """get a query that will create table
    :param table: table name
    :type table: string
    :param schema: schema dict
    :type schema: json
    """

    schema_str = ", ".join(["%s:%s" % (k, schema[k]) for k in sorted(list(schema.keys()))])
    command = '.create-merge table %s (%s)' % (table, schema_str)
    return command