4

I would like to set drill.exec.hashjoin.fallback.enabled as true in system level by starting drillbit.

I can set it during my session like alter session setdrill.exec.hashjoin.fallback.enabled=TRUE;, also I am aware of drill-override.conf file. However, how can I set it by passing an environment variable to my container such as:

    drill:
        image: drill/apache-drill
        restart: always
        environment:
            # - DRILL_EXEC_HASHJOIN_FALLBACK_ENABLED=TRUE
            # - DRILLBIT_JAVA_OPTS="-Ddrill.exec.hashjoin.fallback.enabled=true"
            - DRILLBIT_JAVA_OPTS="-Ddrill.exec.options.drill.exec.hashjoin.fallback.enabled=true"
        tty: true
        volumes:
            - orlando:/orlando
        ports:
            - "8047:8047"
            - "31010:31010"
Olaf Kock
  • 46,930
  • 8
  • 59
  • 90
Can Guney Aksakalli
  • 1,320
  • 1
  • 11
  • 24

1 Answers1

2

Could you please clarify, whether Drill is started in embedded or distributed mode?

For distributed mode, DRILLBIT_JAVA_OPTS=-Ddrill.exec.options.drill.exec.hashjoin.fallback.enabled=true should work as expected, but for embedded, this variable is not considered and should be used DRILL_JAVA_OPTS variable:

- DRILL_JAVA_OPTS=-Ddrill.exec.options.drill.exec.hashjoin.fallback.enabled=true

For more details about variables description, please reffer to https://github.com/apache/drill/blob/master/distribution/src/resources/runbit#L36

Vova Vysotskyi
  • 661
  • 4
  • 8
  • I am using the embedded mode and getting: `Error: Could not find or load main class "-Ddrill.exec.options.drill.exec.hashjoin.fallback.enabled=true"` – Can Guney Aksakalli Oct 16 '19 at 10:20
  • The issue there was with double-quotes in the variable - they are passed as part of the variable value for. It will work either without quotes: `- DRILL_JAVA_OPTS=-Ddrill.exec.options.drill.exec.hashjoin.fallback.enabled=true` or when quoting variable name also: `- "DRILL_JAVA_OPTS=-Ddrill.exec.options.drill.exec.hashjoin.fallback.enabled=true"` I have updated the answer to reflect it. – Vova Vysotskyi Jan 05 '20 at 15:25