database - Not able to create a table in netezza -

-

i new netezza,

i have physical machine installed ubuntu 14.04. in ubuntu 14.04, have installed vmware player , on top of created netezza virtual host.

the above process successful , able login netezza. used below commands connect netezza.

command 1: nzsql -u admin -pw password  system.admin(admin)=> create database test;

and able create database 

system.admin(admin)=>\c test

the above steps worked when tried creating table using below

test.admin(admin)=>create table users(name varchar(20));

it hangs without error or proceeding further:

any appreciated.

thanks

when see state of "discovering" tells system trying boot , bring online spu vm, provides backed mpp processing. state normal few minutes in nzstart process, not if hangs there forever.

when running netezza emulator may find in situation client vm represents spu in netezza host vm gets confused state.

this happen me time time when hibernate vm. following process clears me.

[nz@netezza ~]$ nzstop  warning: nzstop not stop spu virtual machines! if want stop them, use following command:      nzpush -all power off  [nz@netezza ~]$ nzpush -all power off powering off spus spu0101 ...domain spu0101 destroyed   done.   [nz@netezza ~]$ nzpush -all power on powering on spus spu0101 ...domain spu0101 started   done. [nz@netezza ~]$ nzstart nzstart: warning: using user-specified topology: /nz/nse/inittopology.cfg  (startupsvr) info: nz-00022: --- program 'startupsvr' (10693) starting on host 'netezza' ... --- [nz@netezza ~]$ nzstate system state 'online'.

if not work, escalate with:

[nz@netezza ~]$ su - root password:  ############################# # current ip: 192.168.118.111 #############################  [root@netezza ~]# shutdown -r [root@netezza ~]# broadcast message nz@netezza         (/dev/pts/1) @ 14:58 ...  system going down reboot now!

after reboot, system should automatically start database service. let "watch nzstate" run until shows "online." patient while system shows "discovering" here. depending on speed of system may 5 minutes or more.


Comments

Post a Comment

Popular posts from this blog

Fail to load namespace Spring Security http://www.springframework.org/security/tags -

-
i have problem namespace of spring security on xhtml page. don't understand why can't load uri, , have following issue: whitelabel error page application has no explicit mapping /error, seeing fallback. tue jul 21 16:58:12 utc 2015 there unexpected error (type=not found, status=404). please need help! possible uri has been changed? best regards you using incorrect namespace url. correct url http://www.springframework.org/schema/security the error page seeing spring source website since not recognize url. try visiting http://www.springsource.org/security/tags in browser update : spring security tags used in jsp page correct tag lib declaration is: <%@ taglib prefix="sec" uri="http://www.springframework.org/security/tags" %>
Read more

sql - MySQL query optimization using coalesce -

-
can explain me why second query faster first? (first 1 takes around 40 seconds, second 1 less 0.1) select releases.feature_code, releases.platform_id, version, release_date, general_available, uri, filesize, display_name, feature_name.full_name, if ((select exists(select 1 release_exceptions releases.feature_code = release_exceptions.feature_code , releases.platform_id = release_exceptions.platform_id , releases.version = release_exceptions.version) = 1), 1, 0) release_exceptions releases left outer join platform using(platform_id) left outer join feature_name using(feature_code) order version desc; ~~~ query 2 ------------------ ~~~ select feature_code, version, release_date, general_available, platform_id, uri, filesize, display_name, feature_name.full_name, coalesce(release_exceptions, 0) release_exceptions mus.releases left outer join ( select distinct feature_code, version, platform_id, 1 release_exceptions mus.release_exceptions ) release_exceptions using ...
Read more

Maven Javadoc 'Cannot find default setter' and fails -

-
i'm trying generate javadocs maven project, , i'm running error every time. unable parse configuration of mojo org.apache.maven.plugins:maven-javadoc-plugin:2.10.3:javadoc parameter #: cannot find default setter in class org.apache.maven.plugin.javadoc.options.group . command i'm using mvn javadoc:javadoc root directory, pom is. i don't have groups configured @ all, or have special configuration @ all. same error whether omit plugin in pom completely, add reporting, or add build plugin. i've tried adding empty groups well, , while message changes somewhat, still appears. i ran across this question , a. don't have testng dependencies, b. i'm not using command line parameters, , c. never resolved. it selenium project, suppose there similar, can't figure out. ideas? i've included maven debug stack trace below. [error] failed execute goal org.apache.maven.plugins:maven-javadoc-plugin:2.10.3:javadoc (default-cli) on project selenium: un...
Read more