[{"_1":2,"_170":-5,"_171":-5},"loaderData",{"_3":4,"_18":19,"_25":26,"_145":146},"root",{"_5":-5,"_6":-7,"_7":8,"_9":-7,"_10":11,"_12":-7,"_13":14,"_15":16,"_17":11},"currentUser","primaryEmail","siteVerification","6LeIxAcTAAAAAJcZVRqyHh71UMIEGNQ_MXjiZKhI","toast","enableDev",false,"incidentStatus","theme","system","contrast","normal","dockerRebrandTour","routes/_layout",{"_20":-5,"_21":22,"_23":11,"_24":22},"username","isAskGordonEnabled",true,"showMinimalLanding","showHoneypotTrap","routes/_layout.r.$namespace.$reponame",{"_27":28,"_29":-5,"_30":11,"_31":11,"_32":33,"_34":35,"_36":-5,"_37":11,"_38":39,"_89":-5,"_90":91,"_133":-5,"_134":11,"_135":22,"_136":11,"_137":11,"_138":-5,"_139":11,"_140":-5,"_141":142,"_143":92,"_144":-7},"canonicalUrl","https://hub.docker.com/r/trafodion/quickstart/tags","mcpServer","canSeeDockerfile","canSeeAutobuilds","namespace","trafodion","reponame","quickstart","cloudBuildSource","isAutobuildsAvailable","repo",{"_40":41,"_42":43,"_45":46,"_47":48,"_49":11,"_50":51,"_52":53,"_54":55,"_57":35,"_32":33,"_58":59,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":-5,"_68":69,"_70":71,"_72":11,"_73":33,"_74":75,"_80":11,"_81":82,"_86":33,"_87":88},"categories",[],"content_types",[44],"image","date_registered","2016-06-22T13:15:30.48646Z","description","Single node Apache Trafodion 2.1, running on top of HDP 2.4","is_private","last_updated","2017-08-02T19:04:16.056335Z","last_modified","2024-10-16T13:48:34.145251Z","media_types",[56],"application/vnd.docker.distribution.manifest.v1+prettyjws","name","pull_count",3434,"repository_type","star_count",6,"status",1,"status_description","active","source","collaborator_count",0,"full_description","#### Apache WebPage:\nhttp://trafodion.apache.org\n\n#### Install docker:\n1. Edit /etc/yum.repos.d/docker-main.repo :\n```\n [docker-main-repo]\nname=Docker main Repository\nbaseurl=https://yum.dockerproject.org/repo/main/centos/$releasever\nenabled=1\ngpgcheck=1\ngpgkey=https://yum.dockerproject.org/gpg\n```\n2. Install docker: `yum install docker-engine` \n3. Start docker daemon: `service docker start`\n\n#### System Requirement:\nat least 4GB memory for your Linux host which runs docker.\n\n#### Fetch image:\n`docker pull trafodion/quickstart:2.1`\n\n#### Run:\n`\ndocker run -it --privileged=true -h 59b3d431c55c --name=59b3d431c55c -p 8080:8080 -p 23400-23405:23400-23405 -p 4200-4206:4200-4206 -p 24400:24400 trafodion2.1 start\n`\noptions explanation:\n```\n-d Run in daemon mode\n-h [hostname] Specify the docker hostname\n-p [hostport:dockerport] Map the port from host to docker\n--privileged=true Required\n```\n`start` is used to start all Hadoop and Trafodion services while docker is starting.\nTrafodion will be started automatically within 5 minutes (if not, please start Hadoop manually from Hadoop webpage: http://localhost:8080). Then you can ssh to the docker:\n\n```\nssh -p 2201 trafodion@localhost\n```\nThe password of trafodion is `traf123`.\n\ncheck trafodion running status using `sqcheck`:\n```\n[trafodion@trafdocker ~]$ sqcheck\nChecking if processes are up.\nChecking attempt: 1; user specified max: 2. Execution time in seconds: 0.\n\nThe SQ environment is up!\n\n\nProcess\t\tConfigured\tActual\t Down\n-------\t\t----------\t------\t ----\nDTM\t\t 2\t\t2\t \nRMS\t\t 4\t\t4\t \nDcsMaster\t 1\t\t1\t \nDcsServer\t 1\t\t1\t \nmxosrvr\t\t 2\t\t2\n```\nIf not up, please use sqstart to start Trafodion 2.1\nrun trafodion CLI using `trafci`:\n```\n[trafodion@trafdocker ~]$ trafci\n\nWelcome to Apache Trafodion Command Interface \nCopyright (c) 2015-2016 Apache Software Foundation\n\nHost Name/IP Address: localhost:23400\nUser Name: zz\n\nConnected to Trafodion \n\nSQL>get tables;\n\nTables in Schema TRAFODION.SEABASE\n==================================\n \nTEST01\n\n--- SQL operation complete.\n```\n\n#### JDBC connection:\n\nCopy JDBC driver jar file from the docker to host:\n`scp -P 2201 trafodion@localhost:/home/trafodion/trafodion-2.1.0/export/lib/jdbcT4.jar /path/to/jdbcT4.jar`\n\nAdd jar file to CLASSPATH:\n`export CLASSPATH=$CLASSPATH:/path/to/jdbcT4.jar`\n\nThen you can use JDBC to connect Trafodion from host, below is a sample JAVA code:\n\n```\nimport java.sql.Connection;\nimport java.sql.DriverManager;\nimport java.sql.ResultSet;\nimport java.sql.PreparedStatement;\npublic class con {\n protected static String url = \"jdbc:t4jdbc://172.17.0.2:23400/:\"; //set your docker's IP address\n protected static String driverClass = \"org.trafodion.jdbc.t4.T4Driver\";\n protected static String user = \"zz\";\n protected static String pwd = \"zz\";\n protected static Connection conn;\n public static void main(String[] args) throws Exception {\n Class.forName(driverClass);\n conn = DriverManager.getConnection(url, user, pwd);\n String sql = \"select * from test01\";\n PreparedStatement ps = conn.prepareStatement(sql);\n ResultSet rs = ps.executeQuery();\n while (rs.next()){\n System.out.println(rs.getString(1));\n }\n ps.close();\n conn.close();\n }\n}\n```\n\n##### JDBC connect from another host\nModify /home/trafodion/trafodion-2.1.0/dcs-2.1.0/conf/dcs-site.xml within docker, remove below section:\n```\n \n dcs.dns.interface\n eth0\n \n```\nAdd below section:\n```\n\ndcs.cloud.command\necho {docker's ip}, {host's ip}\n\n```\nFor example:\n```\necho 172.17.0.2, 192.168.1.1\n```\n\n#### Stop:\nrun `dokcer ps` to get your container ID, and use `docker stop {container_id}` to stop it.","has_starred","hub_user","immutable_tags_settings",{"_76":11,"_77":78},"enabled","rules",[79],".*","is_automated","permissions",{"_83":22,"_84":11,"_85":11},"read","write","admin","user","storage_size",4913464132,"orgData","recentTags",[92,126],{"_93":44,"_94":95,"_96":97,"_98":99,"_100":101,"_50":115,"_116":95,"_117":33,"_118":56,"_57":119,"_120":121,"_122":-5,"_123":115,"_124":113,"_125":22},"content_type","creator",923046,"full_size",8637571430,"id",13638916,"images",[102],{"_103":104,"_105":106,"_107":-5,"_108":-5,"_109":106,"_110":106,"_111":-5,"_112":69,"_63":113,"_114":-5},"architecture","amd64","features","","last_pulled","last_pushed","os","os_features","os_version","size","inactive","variant","2017-08-02T19:04:15.707205Z","last_updater","last_updater_username","media_type","2.1","repository",759415,"tag_last_pulled","tag_last_pushed","tag_status","v2",{"_93":44,"_94":95,"_96":127,"_98":128,"_100":129,"_50":131,"_116":95,"_117":33,"_118":56,"_57":132,"_120":121,"_122":-5,"_123":131,"_124":113,"_125":22},1189346054,3573095,[130],{"_103":104,"_105":106,"_107":-5,"_108":-5,"_109":106,"_110":106,"_111":-5,"_112":69,"_63":113,"_114":-5},"2016-06-24T12:03:48.312988Z","2.0","sbxKitMetadata","isPotentialSpam","isHubSbxKitsEnabled","showSbxRunInCloud","showSbxLogoOverride","sbxTrademarkText","displaySecurityMetadata","tagAttestations","tagsHaveAttestations",[],"selectedTag","attestationsUrl","routes/_layout.r.$namespace.$reponame.tags",{"_38":147,"_154":155,"_141":168,"_169":11},{"_40":148,"_42":149,"_45":46,"_47":48,"_49":11,"_50":51,"_52":53,"_54":150,"_57":35,"_32":33,"_58":59,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":-5,"_68":69,"_70":71,"_72":11,"_73":33,"_74":151,"_80":11,"_81":153,"_86":33,"_87":88},[],[44],[56],{"_76":11,"_77":152},[79],{"_83":22,"_84":11,"_85":11},"tags",{"_156":157,"_158":-5,"_159":-5,"_160":161},"count",2,"next","previous","results",[162,165],{"_93":44,"_94":95,"_96":97,"_98":99,"_100":163,"_50":115,"_116":95,"_117":33,"_118":56,"_57":119,"_120":121,"_122":-5,"_123":115,"_124":113,"_125":22},[164],{"_103":104,"_105":106,"_107":-5,"_108":-5,"_109":106,"_110":106,"_111":-5,"_112":69,"_63":113,"_114":-5},{"_93":44,"_94":95,"_96":127,"_98":128,"_100":166,"_50":131,"_116":95,"_117":33,"_118":56,"_57":132,"_120":121,"_122":-5,"_123":131,"_124":113,"_125":22},[167],{"_103":104,"_105":106,"_107":-5,"_108":-5,"_109":106,"_110":106,"_111":-5,"_112":69,"_63":113,"_114":-5},[],"canDeleteTags","actionData","errors"]

trafodion/quickstart

Tags for trafodion/quickstart