I resolved the issue by this way https://github.com/chuqbach/Big-Data-Installation/issues/2
Thanks for your help. Regards On Wed, Feb 23, 2022 at 5:49 PM Mich Talebzadeh <mich.talebza...@gmail.com> wrote: > and check that beeline thrift server is indeed running (mine runs on port > 10099) > > netstat -plten|grep 10099 > tcp 0 0 0.0.0.0:10099 0.0.0.0:* > LISTEN 1 > > > > view my Linkedin profile > <https://www.linkedin.com/in/mich-talebzadeh-ph-d-5205b2/> > > > https://en.everybodywiki.com/Mich_Talebzadeh > > > > *Disclaimer:* Use it at your own risk. Any and all responsibility for any > loss, damage or destruction of data or any other property which may arise > from relying on this email's technical content is explicitly disclaimed. > The author will in no case be liable for any monetary damages arising from > such loss, damage or destruction. > > > > > On Wed, 23 Feb 2022 at 09:42, Mich Talebzadeh <mich.talebza...@gmail.com> > wrote: > >> beeline -u jdbc:hive2://localhost:10000/default >> org.apache.hive.jdbc.HiveDriver -n <the user name on unix host where hive >> is running> -p <password for unix user> >> >> >> >> view my Linkedin profile >> <https://www.linkedin.com/in/mich-talebzadeh-ph-d-5205b2/> >> >> >> https://en.everybodywiki.com/Mich_Talebzadeh >> >> >> >> *Disclaimer:* Use it at your own risk. Any and all responsibility for >> any loss, damage or destruction of data or any other property which may >> arise from relying on this email's technical content is explicitly >> disclaimed. The author will in no case be liable for any monetary damages >> arising from such loss, damage or destruction. >> >> >> >> >> On Wed, 23 Feb 2022 at 09:35, Aaron Grubb <aa...@kaden.ai> wrote: >> >>> Try username "root" and empty password. That works for me on 3.1.2. >>> >>> On Wed, 2022-02-23 at 10:16 +0800, Bitfox wrote: >>> >>> Hello >>> >>> I have hive 2.3.9 installed by default on localhost for testing. >>> HDFS is also installed on localhost, which works correctly b/c I have >>> already used the file storage feature. >>> >>> I didn't change any configure files for hive. >>> >>> I can login into hive shell: >>> >>> hive> show databases; >>> >>> OK >>> >>> default >>> >>> Time taken: 4.458 seconds, Fetched: 1 row(s) >>> >>> >>> >>> After started hiveserver2 which works online, I can't connect via >>> beeline: >>> >>> >>> beeline> !connect jdbc:hive2://localhost:10000/default >>> >>> Connecting to jdbc:hive2://localhost:10000/default >>> >>> Enter username for jdbc:hive2://localhost:10000/default: APP >>> >>> Enter password for jdbc:hive2://localhost:10000/default: **** >>> >>> 22/02/23 10:11:41 [main]: WARN jdbc.HiveConnection: Failed to connect to >>> localhost:10000 >>> >>> Could not open connection to the HS2 server. Please check the server URI >>> and if the URI is correct, then ask the administrator to check the server >>> status. >>> >>> Error: Could not open client transport with JDBC Uri: >>> jdbc:hive2://localhost:10000/default: java.net.ConnectException: Connection >>> refused (Connection refused) (state=08S01,code=0) >>> >>> >>> >>> It prompts me to input username and password. >>> >>> I have tried both empty user/pass, and user "APP"/pass "mine". >>> >>> Neither of them will work. >>> >>> >>> >>> How can I fix this and connect to Hive correctly via beeline? >>> >>> >>> Sorry I am the newbie to Hive. >>> >>> >>> Thanks a lot. >>> >>> >>>
