Erron on Big SQL Lab 6
I got an error on lab 6. Do you know what I did wrong?
[localhost][biadmin] 1> create hadoop table if not exists testblogs ( [localhost][biadmin] 2> Country String, [localhost][biadmin] 3> Crawled String, [localhost][biadmin] 4> FeedInfo String, [localhost][biadmin] 5> Inserted String, [localhost][biadmin] 6> IsAdult int, [localhost][biadmin] 7> Language String, [localhost][biadmin] 8> Postsize int, [localhost][biadmin] 9> Published String, [localhost][biadmin] 10> SubjectHtml String, [localhost][biadmin] 11> Tags String, [localhost][biadmin] 12> Type String, [localhost][biadmin] 13> Url String ) [localhost][biadmin] 14> row format serde 'org.apache.hadoop.hive.contrib.serde2.JsonSerde' [localhost][biadmin] 15> location '/user/biadmin/sampleData/SerDe-Test'; SQL Exception(s) Encountered: [State: 58004][Code: 15]: BIGSQL-GEN-0010 Found an internal error: 'Failed to execute query 'create hadoop table if not exists testblogs ( Country String, Crawled String, FeedInfo String, Inserted String, IsAdult int, Language String, Postsize int, Published String, SubjectHtml String, Tags String, Type String, Url String ) row format serde 'org.apache.hadoop.hive.contrib.serde2.JsonSerde' location '/user/biadmin/sampleData/SerDe-Test'': line 1:8: unexpected token: hadoop'.
Hi TiagoMoraes,
Looks like you may be using a jdbc connection that is not bigsql.
From jsqsh shell:
====Shell input====
1>\setup
C --for connection wizard option
--verify that the first row is: 1 bigsql db2 bivm.ibm.com 51000
Q
1>\connect bigsql
Password: biadmin -- or the password you chose.
-- prompt should now read the following:
[bivm.ibm.com][biadmin] 1>
====End shell input====
You should now be able to successfully run the create hadoop table statement.
Hi Carlos,
Thanks for your reply, I was using the following command to connect to bigsql: jsqsh -P <password>. I don't know which connection has been used, but after I followed your suggestion worked. Thanks
Tiago Moraes