The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

kafkaexport doesn't execute in spring mybatis

HyeontaeJuHyeontaeJu Vertica Customer
edited May 2021 in General Discussion

This query execute on dbeaver but spring mybatis not work

error message
[Vertica]VJDBC ERROR: Function emptymap() does not exist, or permission is denied for emptymap()

query
SELECT KafkaExport(null, product_id::VARCHAR, maptoString(mapput(emptymap(), 111, 'CCC', product_id, storepid, title, currency_type, price_pc, price_mobile, normal_price, link, link2, mobile_link, mobile_link2, add_image_link, category_name1, category_name2, category_name3, category_name4, naver_category, naver_product_id, condition, import_flag, parallel_import, order_made, product_flag, adult, goods_type, barcode, manufacture_define_number, model_number, brand, src_brand, maker, origin, card_event, event_words, coupon, partner_coupon_download, interest_free_event, point, installation_costs, pre_match_code, search_tag, group_id, vendor_id, coordi_id, minimum_purchase_quantity, review_count, shipping, delivery_grade, delivery_detail, attribute, option_detail, seller_id, age_group, gender, product_type, mall_id, pipe_id, class, mall_name, registerd_time, update_time, agency_id, billing_type, deleted, image_status, image_link, salestart, saleend, freedlvyn, salelimit, salemax, salecnt, modelnm, poplrdgr, display, vendor_product_id, category_master_code, ws_1depth_code, ws_1depth, ws_2depth_code, ws_2depth, ws_3depth_code, ws_3depth, ws_4depth_code, ws_4depth, ws_5depth_code, ws_5depth, cdn_image_path, cdn_image_name, cdn_image_name_orig, image_checksum, image_clustered_yn, reg_images, image_collect_time, category_status, vendor_category_hash, src_deleted, deleted_time, product_hash, brand_id, brand_status USING parameters keys = SetMapKeys('total','uuid','product_id', 'storepid', 'title', 'currency_type', 'price_pc', 'price_mobile', 'normal_price', 'link', 'link2', 'mobile_link', 'mobile_link2', 'add_image_link', 'category_name1', 'category_name2', 'category_name3', 'category_name4', 'naver_category', 'naver_product_id', 'condition', 'import_flag', 'parallel_import', 'order_made', 'product_flag', 'adult', 'goods_type', 'barcode', 'manufacture_define_number', 'model_number', 'brand', 'src_brand', 'maker', 'origin', 'card_event', 'event_words', 'coupon', 'partner_coupon_download', 'interest_free_event', 'point', 'installation_costs', 'pre_match_code', 'search_tag', 'group_id', 'vendor_id', 'coordi_id', 'minimum_purchase_quantity', 'review_count', 'shipping', 'delivery_grade', 'delivery_detail', 'attribute', 'option_detail', 'seller_id', 'age_group', 'gender', 'product_type', 'mall_id', 'pipe_id', 'class', 'mall_name', 'registerd_time', 'update_time', 'agency_id', 'billing_type', 'deleted', 'image_status', 'image_link', 'salestart', 'saleend', 'freedlvyn', 'salelimit', 'salemax', 'salecnt', 'modelnm', 'poplrdgr', 'display', 'vendor_product_id', 'category_master_code', 'ws_1depth_code', 'ws_1depth', 'ws_2depth_code', 'ws_2depth', 'ws_3depth_code', 'ws_3depth', 'ws_4depth_code', 'ws_4depth', 'ws_5depth_code', 'ws_5depth', 'cdn_image_path', 'cdn_image_name', 'cdn_image_name_orig', 'image_checksum', 'image_clustered_yn', 'reg_images', 'image_collect_time', 'category_status', 'vendor_category_hash', 'src_deleted', 'deleted_time', 'product_hash', 'brand_id', 'brand_status'))) USING PARAMETERS brokers = 'kafka:9092', topic='vertica_big3') OVER (PARTITION BEST) FROM wmp_ep_product_dev.products WHERE product_id LIKE 'AAA%'

Answers

  • SergeBSergeB - Select Field - Employee

    select * from user_functions where function_name ilike 'emptymap' limit 1;
    shows that EmptyMap is in the public schema.
    Maybe when running in spring mybatis, you have a wrong search_path or a user without proper privileges?

  • ThePebbleThePebble Vertica Employee Employee

    This could also be a sign that the flextable udx is not loaded. It should have been loaded by /opt/vertica/packages/flextable/ddl/install.sql

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file