Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-20814

New create function between HiveServer2 is not synchronized

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Reopened
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.1.0
    • Fix Version/s: None
    • Component/s: Beeline
    • Labels:
      None

      Description

      I am using CDH open source version 5.15.0, where the Hive version is 1.1.0.

      I have 3 Metastore services and 3 HiveServer2 services in the cluster, Metastore and HiveServer2 don't currently have HA turned on. The cluster opens the Sentry service and configures the Hive Auxiliary JARs Directory attribute.

      Now I am having a problem, I am using beeline to connect to HiveServer2 on node 1 to create a function that is successful and can be queried normally. But if I now connect to HiveServer2 of node 2 via Beeline, I can't see the function I just created on node 1 through show function. I have to restart HiveServer2 or use reload function command on node 2 to see the function created on node 1 just now.

      Is there a way to implement the function that I can create on any node? I don't know the reason and solution for this problem, I hope I can get help, thank you!

       

      exp:

      connect dn1.test.com:10000 to create function zzytest_trans , use show functions I can see it

       

      At this point I used beeline to connect to dn4.test.com:10000 and use the show functions command to view the function and I can't find the zzytest_trans function. I have to restart HiveServer2 or use reload function command on the dn4.test.com node to see the zzytest_trans function.

       

       

       

       

       

       

        Attachments

        1. image-2018-10-26-10-23-48-101.png
          80 kB
          leozhang
        2. image-2018-10-26-10-24-16-669.png
          80 kB
          leozhang
        3. image-2018-10-26-10-24-54-904.png
          11 kB
          leozhang
        4. image-2018-10-26-10-26-00-591.png
          49 kB
          leozhang
        5. image-2018-10-26-10-27-32-291.png
          15 kB
          leozhang

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              leozhang leozhang
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Due:
                Created:
                Updated: