Thank you for the information.

On Fri, Mar 26, 2021 at 5:14 PM David Anderson <[email protected]> wrote:

> There needs to be a Flink session cluster available to the SQL client on
> which it can run the jobs created by your queries. See the Getting Started
> [1] section of the SQL Client documentation for more information:
>
> The SQL Client is bundled in the regular Flink distribution and thus
> runnable out-of-the-box. It requires only a running Flink cluster where
> table programs can be executed. For more information about setting up a
> Flink cluster see the Cluster & Deployment part [2]. If you simply want to
> try out the SQL Client, you can also start a local cluster with one worker
> using the following command:
>
> ./bin/start-cluster.sh
>
>
> [1]
> https://ci.apache.org/projects/flink/flink-docs-stable/dev/table/sqlClient.html#getting-started
> [2]
> https://ci.apache.org/projects/flink/flink-docs-stable/deployment/resource-providers/standalone
>
> Regards,
> David
>
> On Fri, Mar 26, 2021 at 9:50 AM Yik San Chan <[email protected]>
> wrote:
>
>> The question is cross-posted in Stack Overflow
>> https://stackoverflow.com/questions/66813644/flink-sql-client-select-hello-world-throws-error-could-not-execute-sql-stat
>> .
>>
>> I am following Flink SQL client docs
>> https://ci.apache.org/projects/flink/flink-docs-stable/dev/table/sqlClient.html#dependencies.
>> Opening the Flink SQL client looks fine, but `SELECT 'hello world'` doesn't
>> work.
>>
>> ```
>> $ /data/apache/flink/flink-1.12.0/bin/sql-client.sh embedded
>> SLF4J: Class path contains multiple SLF4J bindings.
>> SLF4J: Found binding in
>> [jar:file:/data/apache/flink/flink-1.12.0/lib/log4j-slf4j-impl-2.12.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
>> SLF4J: Found binding in
>> [jar:file:/data/apache/hadoop/hadoop-2.7.3/share/hadoop/common/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class]
>> SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an
>> explanation.
>> SLF4J: Actual binding is of type
>> [org.apache.logging.slf4j.Log4jLoggerFactory]
>> No default environment specified.
>> Searching for
>> '/data/apache/flink/flink-1.12.0/conf/sql-client-defaults.yaml'...found.
>> Reading default environment from:
>> file:/data/apache/flink/flink-1.12.0/conf/sql-client-defaults.yaml
>> No session environment specified.
>>
>> Command history file path: /data/home/pal-flink/.flink-sql-history
>>                                    ▒▓██▓██▒
>>                                ▓████▒▒█▓▒▓███▓▒
>>                             ▓███▓░░        ▒▒▒▓██▒  ▒
>>                           ░██▒   ▒▒▓▓█▓▓▒░      ▒████
>>                           ██▒         ░▒▓███▒    ▒█▒█▒
>>                             ░▓█            ███   ▓░▒██
>>                               ▓█       ▒▒▒▒▒▓██▓░▒░▓▓█
>>                             █░ █   ▒▒░       ███▓▓█ ▒█▒▒▒
>>                             ████░   ▒▓█▓      ██▒▒▒ ▓███▒
>>                          ░▒█▓▓██       ▓█▒    ▓█▒▓██▓ ░█░
>>                    ▓░▒▓████▒ ██         ▒█    █▓░▒█▒░▒█▒
>>                   ███▓░██▓  ▓█           █   █▓ ▒▓█▓▓█▒
>>                 ░██▓  ░█░            █  █▒ ▒█████▓▒ ██▓░▒
>>                ███░ ░ █░          ▓ ░█ █████▒░░    ░█░▓  ▓░
>>               ██▓█ ▒▒▓▒          ▓███████▓░       ▒█▒ ▒▓ ▓██▓
>>            ▒██▓ ▓█ █▓█       ░▒█████▓▓▒░         ██▒▒  █ ▒  ▓█▒
>>            ▓█▓  ▓█ ██▓ ░▓▓▓▓▓▓▓▒              ▒██▓           ░█▒
>>            ▓█    █ ▓███▓▒░              ░▓▓▓███▓          ░▒░ ▓█
>>            ██▓    ██▒    ░▒▓▓███▓▓▓▓▓██████▓▒            ▓███  █
>>           ▓███▒ ███   ░▓▓▒░░   ░▓████▓░                  ░▒▓▒  █▓
>>           █▓▒▒▓▓██  ░▒▒░░░▒▒▒▒▓██▓░                            █▓
>>           ██ ▓░▒█   ▓▓▓▓▒░░  ▒█▓       ▒▓▓██▓    ▓▒          ▒▒▓
>>           ▓█▓ ▓▒█  █▓░  ░▒▓▓██▒            ░▓█▒   ▒▒▒░▒▒▓█████▒
>>            ██░ ▓█▒█▒  ▒▓▓▒  ▓█                █░      ░░░░   ░█▒
>>            ▓█   ▒█▓   ░     █░                ▒█              █▓
>>             █▓   ██         █░                 ▓▓        ▒█▓▓▓▒█░
>>              █▓ ░▓██░       ▓▒                  ▓█▓▒░░░▒▓█░    ▒█
>>               ██   ▓█▓░      ▒                    ░▒█▒██▒      ▓▓
>>                ▓█▒   ▒█▓▒░                         ▒▒ █▒█▓▒▒░░▒██
>>                 ░██▒    ▒▓▓▒                     ▓██▓▒█▒ ░▓▓▓▓▒█▓
>>                   ░▓██▒                          ▓░  ▒█▓█  ░░▒▒▒
>>                       ▒▓▓▓▓▓▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒░░▓▓  ▓░▒█░
>>
>>     ______ _ _       _       _____  ____  _         _____ _ _
>>  _  BETA
>>    |  ____| (_)     | |     / ____|/ __ \| |       / ____| (_)          |
>> |
>>    | |__  | |_ _ __ | | __ | (___ | |  | | |      | |    | |_  ___ _ __ |
>> |_
>>    |  __| | | | '_ \| |/ /  \___ \| |  | | |      | |    | | |/ _ \ '_ \|
>> __|
>>    | |    | | | | | |   <   ____) | |__| | |____  | |____| | |  __/ | | |
>> |_
>>    |_|    |_|_|_| |_|_|\_\ |_____/ \___\_\______|  \_____|_|_|\___|_|
>> |_|\__|
>>
>>         Welcome! Enter 'HELP;' to list all available commands. 'QUIT;' to
>> exit.
>>
>>
>> Flink SQL> SELECT 'Hello World';
>> [ERROR] Could not execute SQL statement. Reason:
>> org.apache.flink.runtime.client.JobSubmissionException: Failed to submit
>> JobGraph.
>> ```
>>
>> Any help? Thanks.
>>
>> Best,
>> Yik San
>>
>

Reply via email to